WingchairAndy
New Member
- Joined
- Jul 20, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi
The table on the right updates automatically based on the data for that week. What I want to do is then copy & paste the data into the table on the left based on the latest date - which changes each week. The date in the column on the left do not change, so effectively I want to copy the data in the right hand row, run a lookup based on the 19/07/13 and find the 19/07/13 in the left table & paste the row data so it creates a weekly collation of data.
Any help would be appreciated
Regards
Andrew
The table on the right updates automatically based on the data for that week. What I want to do is then copy & paste the data into the table on the left based on the latest date - which changes each week. The date in the column on the left do not change, so effectively I want to copy the data in the right hand row, run a lookup based on the 19/07/13 and find the 19/07/13 in the left table & paste the row data so it creates a weekly collation of data.
Any help would be appreciated
Regards
Andrew
