markster
Well-known Member
- Joined
- May 23, 2002
- Messages
- 579
- Office Version
- 365
- Platform
- Windows
- MacOS
I've got a massive scheduling job to do from a spreadsheet with about 1300 lines and could really do with some VBA code to help me.
There are three sheets:
SHEET 1 - Details of working patterns - data is contained in columns A to W but I've hidden some columns so the screen shot isn't too big
SHEET 2 - Individual Weeks, Dates and Days of the week
SHEET 3 - The summary I need to be created by the Macro from Sheets 1 & 2
In order to create the summary I need in SHEET 3, it needs to look at 2 key columns in SHEET 1 (Column G - Week Range & Column Q Day Range) and Columns - A-F in SHEET 2. In the summary, it splits out out the week numbers into separate lines with actual dates and includes all data from SHEET 1 (I mean entire row of data A to W). I could try to explain it more in words but I think looking at the SHEET 3 screenshot illustrates what I need and trying to explain further might cause confusion. Obviously, I'm happy to answer any questions you may have.
SHEET 1 - Details of working patterns - data is contained in columns A to W but I've hidden some columns so the screen shot isn't too big
Sheet 2 - Individual Weeks, Dates and Days of the week
Sheet 3 - The summary I need to be created by the Macro from Sheets 1 & 2 (Desired Output)
Thanks
Mark
There are three sheets:
SHEET 1 - Details of working patterns - data is contained in columns A to W but I've hidden some columns so the screen shot isn't too big
SHEET 2 - Individual Weeks, Dates and Days of the week
SHEET 3 - The summary I need to be created by the Macro from Sheets 1 & 2
In order to create the summary I need in SHEET 3, it needs to look at 2 key columns in SHEET 1 (Column G - Week Range & Column Q Day Range) and Columns - A-F in SHEET 2. In the summary, it splits out out the week numbers into separate lines with actual dates and includes all data from SHEET 1 (I mean entire row of data A to W). I could try to explain it more in words but I think looking at the SHEET 3 screenshot illustrates what I need and trying to explain further might cause confusion. Obviously, I'm happy to answer any questions you may have.
SHEET 1 - Details of working patterns - data is contained in columns A to W but I've hidden some columns so the screen shot isn't too big
Sheet 2 - Individual Weeks, Dates and Days of the week
Sheet 3 - The summary I need to be created by the Macro from Sheets 1 & 2 (Desired Output)
Thanks
Mark