Copy Data from One Sheet to Another Based on Date Chosen

tigerdel

New Member
Joined
Oct 13, 2015
Messages
40
Posted to ExcelGuru: https://www.excelguru.ca/forums/showthread.php?9998-Copy-Data-from-One-Sheet-to-Another-Based-on-Date-Chosen

In my file, I have a sheet that contains the entire roster over many months [and years] - called Full Roster

To make it easier for the user to locate the required Roster for completion, I have created a sheet called Input sheet.

This is what I would like to do with it:

1. The user opens the Input Sheet [will be renamed later]

2. Enter the date required [Must be a Monday Date

3. The file will then locate the correct date in the Full Roster sheet and copy the data for the entire week [Monday - Sunday] - Rows 3:68 for that week and paste them into Columns H:N in the Input sheet

4. Once the update is complete the user either clicks a button and it then copies the new data back to the correct place in the Full Roster sheet or automatically copies as changes are made [though this method would or could update up to 23600 times if all fields are changed


Any ideas how I might achieve this??


Happy for it to use formulas or VBA


Thanks for looking guys and I will continue to try for myself and update if I get anywhere close

Happy to provide sample file but unable to create attachments as not allowed :(


 

Forum statistics

Threads
1,077,994
Messages
5,337,611
Members
399,156
Latest member
RaudMees

Some videos you may like

This Week's Hot Topics

Top