Automate routine tasks in excel
- or -
Post a project like this1745
£60(approx. $75)
- Posted:
- Proposals: 16
- Remote
- #2443026
- Awarded
Excel and VBA expert. Professional OCR. PDF to Excel Conversion. Data management, Translations English Russian
Hua Hin
TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting
Bay Minette
315561365275649865110463012280501264463144943314494731711586179269425224802743343
Description
Experience Level: Entry
I need simple Excel VBA code from macros to automate a few common/routine tasks that I can frequently use as follows:
1) Import worksheets from other files from a location/path (pick a file at run time or from a specified location)
2) concatenate one or many columns together using my formulas on the imported worksheet
3) vlookup a field from another imported worksheet or from a reference table within the template
4) Summarise the data into a separate summary worksheet by a specific column or columns (ex:pivot tables) and calculate sum, count, average, %, group by date age etc.,
I want to create a template execution file with command buttons for each task that I can use as and when needed depending on the demand at the time.
Please note that the number of rows/columns in the import worksheets can vary.
I am not an expert in macros and I don't want to learn VBA but I want to know enough VBA for the macro to work on any data set irrespective of how many rows of data there is in the import file and what formula I want to use.
This is quite simple to do for someone who knows what they are doing and doesn't take long to do using a simple set of sample data and creating macros, then telling me where in the code I should modify to use the formulas I want to create columns for concatenation, vlookup, pivot etc.,
Is this something that can be taught on-line via skype in a day or two considering I am in UK?
Let me know,
Regards,
Prasad.
1) Import worksheets from other files from a location/path (pick a file at run time or from a specified location)
2) concatenate one or many columns together using my formulas on the imported worksheet
3) vlookup a field from another imported worksheet or from a reference table within the template
4) Summarise the data into a separate summary worksheet by a specific column or columns (ex:pivot tables) and calculate sum, count, average, %, group by date age etc.,
I want to create a template execution file with command buttons for each task that I can use as and when needed depending on the demand at the time.
Please note that the number of rows/columns in the import worksheets can vary.
I am not an expert in macros and I don't want to learn VBA but I want to know enough VBA for the macro to work on any data set irrespective of how many rows of data there is in the import file and what formula I want to use.
This is quite simple to do for someone who knows what they are doing and doesn't take long to do using a simple set of sample data and creating macros, then telling me where in the code I should modify to use the formulas I want to create columns for concatenation, vlookup, pivot etc.,
Is this something that can be taught on-line via skype in a day or two considering I am in UK?
Let me know,
Regards,
Prasad.
Prasad M.
100% (6)Projects Completed
7
Freelancers worked with
6
Projects awarded
82%
Last project
27 Mar 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies