Command button to find data in different sheet, split data and paste in another sheet

Zimmerman

Well-known Member
Joined
Jan 22, 2009
Messages
663
I have a workbook that has a tab for each month of the year. So more or less each tab is just a calendar. So for each day of the week in each calendar there are 6 cells for each day a user can enter data in. For example Thursday the 22nd of November is in cells E25-E30. These are cells where a user will enter their initials, customer and hours worked. So cell E25 could say "J.D. - Home Depot - 6 hours". Cell E26 could say "J.S. - Lowes - 5 hours" and so on down. This is set up like this for each day of the week. Now there is a billing sheet also. For this example it's called "Nov. Billing". What I'd like to do is add a button on the billing sheet that would go grab all the data entered from the user(s) for each day of that month and enter it on this billing sheet. So it would need to look up that month, copy the data into row B25 - B15 and up pasting the data in the next available row. So for this, cell B15 would read "J.D.", C15 would read "Home Depot" and cell D15 would read "6 hours". Cell B16 would read "J.S.", cell C16 would read "Lowes" and cell D16 would read "5 hours". Anybody have any good ideas how I could accomplish this?

Thanks in advance
Excel 2016
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Sorry... :eeek:
I would begin by redesigning totally and have FOUR columns and only ONE sheet containing all the data for all months
Date \ Initials \ Customer \ Hours (may need a further column to identify "month" if not strictly calendar month based)
That makes it easy to input and summarise data

If you want the "original look" the data can then be easily "pulled" to individual monthly sheets

:warning: It is much harder to do what you want
- spiltting out "mixed" unpredictable, inconsistent user input can be a never-ending nightmare :banghead:
 
Last edited:
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

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