V
Very Basic User
Hello All,
I have a spreadsheet document. In the document, there are two seperate
sheets. 1 sheet holds a full calendar year worth of information. The other
sheet, the user will enter a week start date and dates for each day of the
week are automatically updated. The user fills in information throughout the
week. On the bottom of the page, it sums up information by day. What I need
is a way to have a macro that when hit, will look at the current date on the
daily data sheet entry form, copy it, find the correct date on the calendar
sheet, and then paste as values the information. Any assistance would be
greatly appreciated
I have a spreadsheet document. In the document, there are two seperate
sheets. 1 sheet holds a full calendar year worth of information. The other
sheet, the user will enter a week start date and dates for each day of the
week are automatically updated. The user fills in information throughout the
week. On the bottom of the page, it sums up information by day. What I need
is a way to have a macro that when hit, will look at the current date on the
daily data sheet entry form, copy it, find the correct date on the calendar
sheet, and then paste as values the information. Any assistance would be
greatly appreciated