Macro master for quick job.
- or -
Post a project like this$15
- Posted:
- Proposals: 5
- Remote
- #1654580
- Expired
Description
Experience Level: Entry
General information for the business: Data analysis
Description of excel work: Hi - I need someone to create a Macro for me - it should be fairly simple but it will involved a few steps.
Explanation:
This will be in two parts.
Part 1:
I have data in the attached in the range G:N.
Row 4 is name
G is date
The content in the cells (I5:n) is data we need.
Iniitally the macro should do the following:
Create lists as seen in R:S, whereby the date is at the top of each section, and it's gruoped by the data for each person. you shoudl see this is almost-transposed.
-Then copy this data to a new sheet.
---
Part 2.
If I add new data to the spreadsheet - e.g. a new date, new names and press the macro button - it will do part 1 again, adding the data to a new sheet, but ALSO copy the data from the old sheet - meaning I have a much longer list of things to do for each data.
This should be 20 mins work for someone who is good.
Thanks
Then If I
Extra notes:
Description of excel work: Hi - I need someone to create a Macro for me - it should be fairly simple but it will involved a few steps.
Explanation:
This will be in two parts.
Part 1:
I have data in the attached in the range G:N.
Row 4 is name
G is date
The content in the cells (I5:n) is data we need.
Iniitally the macro should do the following:
Create lists as seen in R:S, whereby the date is at the top of each section, and it's gruoped by the data for each person. you shoudl see this is almost-transposed.
-Then copy this data to a new sheet.
---
Part 2.
If I add new data to the spreadsheet - e.g. a new date, new names and press the macro button - it will do part 1 again, adding the data to a new sheet, but ALSO copy the data from the old sheet - meaning I have a much longer list of things to do for each data.
This should be 20 mins work for someone who is good.
Thanks
Then If I
Extra notes:
James S.
98% (49)Projects Completed
44
Freelancers worked with
39
Projects awarded
55%
Last project
26 Oct 2023
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