Good morning
First post here so please be kind.
I have a spreadsheet which is comprised of a date column (A) using =Today(), 2 dependent drop down boxes (columns B & C) which then generate numbers based on Vlookups (columns D, E, F &G). The numbers in columns D to G are then totalled in row 34 which gives the user totals for "today". I need the information in the total row to be copied into another sheet in order to be able to create a 'weekly diary' before clearing the data in sheet 1 so that the user can enter information for the next day. I know how to create a macro with an active X control to clear the data but I have no idea how to copy the total row, the contents of which will change on a daily basis before being cleared, to another worksheet. The second worksheet must keep the 'daily total' information for a period of one week i.e. 7 days, before that data is then also cleared.
I am assuming that this is possible with VBA code but I am a complete novice and really have no idea where to start. Thanks so much in advance for any help.
Have a great day
First post here so please be kind.
I have a spreadsheet which is comprised of a date column (A) using =Today(), 2 dependent drop down boxes (columns B & C) which then generate numbers based on Vlookups (columns D, E, F &G). The numbers in columns D to G are then totalled in row 34 which gives the user totals for "today". I need the information in the total row to be copied into another sheet in order to be able to create a 'weekly diary' before clearing the data in sheet 1 so that the user can enter information for the next day. I know how to create a macro with an active X control to clear the data but I have no idea how to copy the total row, the contents of which will change on a daily basis before being cleared, to another worksheet. The second worksheet must keep the 'daily total' information for a period of one week i.e. 7 days, before that data is then also cleared.
I am assuming that this is possible with VBA code but I am a complete novice and really have no idea where to start. Thanks so much in advance for any help.
Have a great day