Previous Topic Next Topic

Copying macro

Closed
kolis29 - Mar 15, 2012 at 04:01 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 24, 2012 at 04:00 PM
Hi guys,
I'm new to macros and I need your help. I've got an excel file called "DATA.xlsm" and I need to copy some cells from another excel file, which is daily report and it's name is based on date (e.g. DR_15032012.xlsx) so each day another name. I would like to have a macro that would copy certain cells for certain date(e.g. if I need to copy data for 10th March I just place a cursor to row with this date in file "DATA.xlsm" start macro and this will copy data from file DR_10032012.xlsx to certain cells)
Is this possible?
Any help appreciated...many thanks

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 24, 2012 at 04:00 PM
Lets say if the date on the cell is already like 15032012

then you can have in macro

fileName = "DR_" & activecell

if date is not in that format
you can have some thing like this
fileName = "DR_" & format(activecell,"ddmmyyyy")
0

Similar discussions

Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

1 response
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

5 responses
Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
How to convert number into text in Excel
boratechandu -
Raj -

9 responses