Copy Data from One Sheet to Another Based on Date Chosen

tigerdel

Board Regular
Joined
Oct 13, 2015
Messages
145
Office Version
  1. 365
Platform
  1. Windows
Posted to ExcelGuru: https://www.excelguru.ca/forums/sho...rom-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 :(


 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,213,494
Messages
6,113,981
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top