tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,210
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I download our sales from the system in a big list of up to 14 days
I want a macro that will give me each day's figures in their own area,
I have a sheet Called days that I've set up the headers for each of the 14 days.
I want to put a start date end date, start time, end time into cells run a macro and it splits the data up for me,
however, because we are a 24-hour business I might want to start time to be 7pm and the end time be 3am effectively going into the next day.
So to Elaborate this is what I'm looking for
I have a sheet named raw which holds all the downloaded data, row 1 is the headers.
the columns to copy are A to Y
In AB7 I have start date
AB8 end date
Ab10 start time
AB11 end time
So I need the macro to be smart enough to realise that sometimes the end time is the next day.
but all I want is for the macro to go right, day one is "Start day/ Start time, until start day/end time", (if end time is after 23:59 the its Start day +1 /end time)
then copy that data into sheet "Day" A2 paste values, then go right, next day is Start day+1/ Start time, until start day+1/end time, (if end time is after 23:59 the its Start day +2 /end time)
copy and paste into "Day" AA2 paste values and so on for each day chosen.
Please help if you can.
Thanks
Tony
I download our sales from the system in a big list of up to 14 days
I want a macro that will give me each day's figures in their own area,
I have a sheet Called days that I've set up the headers for each of the 14 days.
I want to put a start date end date, start time, end time into cells run a macro and it splits the data up for me,
however, because we are a 24-hour business I might want to start time to be 7pm and the end time be 3am effectively going into the next day.
So to Elaborate this is what I'm looking for
I have a sheet named raw which holds all the downloaded data, row 1 is the headers.
the columns to copy are A to Y
In AB7 I have start date
AB8 end date
Ab10 start time
AB11 end time
So I need the macro to be smart enough to realise that sometimes the end time is the next day.
but all I want is for the macro to go right, day one is "Start day/ Start time, until start day/end time", (if end time is after 23:59 the its Start day +1 /end time)
then copy that data into sheet "Day" A2 paste values, then go right, next day is Start day+1/ Start time, until start day+1/end time, (if end time is after 23:59 the its Start day +2 /end time)
copy and paste into "Day" AA2 paste values and so on for each day chosen.
Please help if you can.
Thanks
Tony