Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to paste value to a file same as A1
I have a file (Master.xls) with several sheets with different names. A1 in
each sheet is same of Sheet name (ABC, MNO etc) and I also have different files as per each sheet (ABC.xls, MNO.xls etc) which will be open. Right now I have separate macro for each sheet as I need to update some values from master.xls to ABC.xls or MNO.xls etc as per sheet names. can I have a single macro so that it will update the values from master.xls to ABC.xls or MNO.xls etc according to name in A1 in each sheet. Also, I'll not be updating values from all the tabs in master.xls at once. May be from only one sheet at a time.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy and paste values (columns)I have a macro file built | Excel Programming | |||
how to paste macro to a newly created file using vba | Excel Programming | |||
Cut and Paste Macro to new file | Excel Discussion (Misc queries) | |||
copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
Select File Copy/Paste Macro Help.... | Excel Programming |