Hi All,
Hope you are well and keeping safe.
I need some help converting a table into rows.
I have attached an example with some data which hope helps understand.
1. Prompt user for 'Start Date', then 'Number of days'. Default will be 7.
2. Find date in Row 1 (Sheet1).
3. Copy/paste 'Dates' to Sheet3 (Date).
4. Check the 'Number' column (Sheet1) up to the last number - so anything up to 'Reserve'.
5. Copy to Sheet3 (same name).
Note: Numbers may be added/removed (Sheet2) - so is important for the count up to 'Reserve' - Reserve excluded.
6. Copy each column to match Date/Number.
For example;
Start Date = 4/2/21
Number of days = 4
Result = See Sheet4
Hopefully this makes sense and someone can help soon to save me from this laborious task!
Thanks in advance.
Best,
Al
Bookmarks