Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding ws information to cell in new wb & saving with ws name
I am trying to select cells in one workbook with multiple sheets and enter
them into multiple workbooks which would each be named and saved with the same name as the worksheet they came from in the old workbook. For example, the first worksheet in workbook "Trollie" is named "White". I am opening another workbook (previously created, named "UDF") and copy cells c79,c80,c81,c88,c89,c91,and c95 of "Trollie" into cells in column A of "UDF". I then want to save "UDF" with the name "White" (as in the name of the worksheet in "Trollie"). I need to do this with each worksheet in the workbook "Tollie". Can anyone please help with this? -- Thank you, Jodie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving information to PERSONAL.XLS | Excel Programming | |||
COPYING AND SAVING THE INFORMATION | Excel Discussion (Misc queries) | |||
Saving information between uses? (Userform) | Excel Programming | |||
adding cell data into a macro to allow specified information filte | Excel Programming | |||
Saving Information on Userforms | Excel Programming |