Johnny Thunder
Well-known Member
- Joined
- Apr 9, 2010
- Messages
- 693
- Office Version
- 2016
- Platform
- MacOS
Hi everyone!
I am stuck on a task that I am not sure how to accomplish but it is pretty straightforward. My workbook has several sheets that I can put into an array that I want to extract only the first row of data E4:V4 and paste these values into Sheets("Daily Log") starting in the same range of E4:V4 and just move down the sheet based on how many tabs there.
In a nutshell, I have several sheets with itemized detail, this "Daily Log" serves as a quick snapshot to only show the latest activity from that specific sheet which happens to always be the first row in the report.
Code Steps Needed:
1. Wipe the old Data Clear, Sheets("Daily Log").Range("E4:V" & Lastrow).ClearContents
2. Identify how many sheets need to have data extracted - It will be easier to just identify the sheets to not loop thru than to always add new sheets to the array.
4. Move one row down on the daily log for the next sheets data
5. End Loop and now your done.
If anyone has any ideas I would appreciate it! Thanks!
I am stuck on a task that I am not sure how to accomplish but it is pretty straightforward. My workbook has several sheets that I can put into an array that I want to extract only the first row of data E4:V4 and paste these values into Sheets("Daily Log") starting in the same range of E4:V4 and just move down the sheet based on how many tabs there.
In a nutshell, I have several sheets with itemized detail, this "Daily Log" serves as a quick snapshot to only show the latest activity from that specific sheet which happens to always be the first row in the report.
Code Steps Needed:
1. Wipe the old Data Clear, Sheets("Daily Log").Range("E4:V" & Lastrow).ClearContents
2. Identify how many sheets need to have data extracted - It will be easier to just identify the sheets to not loop thru than to always add new sheets to the array.
2a. Sheets to not Loop Thru: "Control Sheet", "Daily Log", "Lookups"
3. Loop thru each sheet and if there is data in Row 4, Extract that row using range (E4:V4) and paste in the Daily Log4. Move one row down on the daily log for the next sheets data
5. End Loop and now your done.
If anyone has any ideas I would appreciate it! Thanks!