Abhishekghorpade
Board Regular
- Joined
- Oct 3, 2018
- Messages
- 78
Hi,
I have data in multiple sheets in active workbook.
Each sheet has unique ID in cell H1 and each sheet has value in ‘column G’ and Date in ‘column A’.
I want to copy paste the unique ID and value in ‘column G’ and yesterday’s date (excluding weekends) in new sheet.
Thank you so much in advance
I have data in multiple sheets in active workbook.
Each sheet has unique ID in cell H1 and each sheet has value in ‘column G’ and Date in ‘column A’.
I want to copy paste the unique ID and value in ‘column G’ and yesterday’s date (excluding weekends) in new sheet.
Thank you so much in advance