I need a visual basic/macro created for a spreadsheet
- or -
Post a project like this3313
$$
- Posted:
- Proposals: 10
- Remote
- #723111
- Completed
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
Industry: Education
Description of excel work: Hopefully this job will be simple for someone who knows there way around excel!
Please see attached spreadsheet job document.xlsx and also attached pdf excel_diagram.pdf
I need a macro or similar that will add a new row on the Agenda Items worksheet each time a value is encountered in columns I, J, K and L in the delegates worksheet.
Each value that is encountered must be a separate row on the Agenda Items worksheet
Agenda Items worksheet columns
• A: must be a unique number in numerical order
• B: relates to column A on delegates worksheet this value should be copied to column B each time a new row is created
• C: please ignore
• D: relates to the values found in each row on delegates worksheet in columns I, J, K and L (only one value from any of these columns is allowed in each row on Agenda Items worksheet )
• E: please ignore
The macro must also:
Skip empty fields
Process all the rows in the document (more rows will be added over time)
Any questions please let me know!
Extra notes:
Description of excel work: Hopefully this job will be simple for someone who knows there way around excel!
Please see attached spreadsheet job document.xlsx and also attached pdf excel_diagram.pdf
I need a macro or similar that will add a new row on the Agenda Items worksheet each time a value is encountered in columns I, J, K and L in the delegates worksheet.
Each value that is encountered must be a separate row on the Agenda Items worksheet
Agenda Items worksheet columns
• A: must be a unique number in numerical order
• B: relates to column A on delegates worksheet this value should be copied to column B each time a new row is created
• C: please ignore
• D: relates to the values found in each row on delegates worksheet in columns I, J, K and L (only one value from any of these columns is allowed in each row on Agenda Items worksheet )
• E: please ignore
The macro must also:
Skip empty fields
Process all the rows in the document (more rows will be added over time)
Any questions please let me know!
Extra notes:
Rob H.
100% (1)Projects Completed
3
Freelancers worked with
3
Projects awarded
80%
Last project
16 May 2016
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