Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi. Sorry if this question has been posted before, but I can't seem to find any solution for this. I'm trying to create a macro (I think) that would allow me to copy a whole worksheet and paste it to another new worksheet in Excel. The problem is that everyday, there are new data added to the worksheet with the current date. Hence I want to copy the data from the current date and paste it to a new worksheet. Also there are 49 databases with the new data each date and it needs to be copied all into one worksheet. Any help would be appreciated. -- alucard ------------------------------------------------------------------------ alucard's Profile: http://www.excelforum.com/member.php...o&userid=27764 View this thread: http://www.excelforum.com/showthread...hreadid=472702 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
Problem using Day() in a macro | Excel Worksheet Functions | |||
Problem with Macro | Excel Discussion (Misc queries) | |||
macro problem | Excel Discussion (Misc queries) |