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
Thanks in advance
Excel 2016