VBA Take set range of data and move to another sheet by corresponding date

cspiker23

New Member
Joined
Sep 14, 2017
Messages
3
Good Morning, I am trying to make a daily reporting log for my employees. They would enter production totals from the day and select a date for the given reporting day on a "daily" sheet. On a second sheet labeled "yearly" I would have column A listing dates and I am wanting the data from the "daily" sheet to move to the "yearly" sheet in the following necessary columns starting at the B column next to the necessary found date entered on the "daily" sheet. I can tweek ranges in the code I am mostly looking for the main language to do so. Please let me know if I can or need to be more detailed. Thanks ahead of time for any help.
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Please guys/gals any help is big help. On the Daily sheet I will have a range of data in a row that I am looking to transfer to the yearly sheet on the same amount of cells in a row. Thanks
 
Upvote 0

Forum statistics

Threads
1,223,897
Messages
6,175,270
Members
452,628
Latest member
dd2

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