Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to copy formatting when moving from cell to variable to another cell on another worksheet
I am taking data from 15 different cells on one workbook and want to
move it to another workbook where the data from the cells is arranged in a different order, so I can't "copy and pastespecial paste:=ValuesAndNumbersFormat" in one move. I've taken the values from cells in the first wrkbook & set them to individual variables, activated the second wrkbook & progressed from variables to cells. Is there a better way, when the data is not entered in the same cells in both workbooks, not even relatively? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy cell from file with variable name | Excel Worksheet Functions | |||
copy last populated cell (moving) to another cell | Excel Discussion (Misc queries) | |||
Entire worksheet moves when moving from cell to cell | Excel Discussion (Misc queries) | |||
Moving active cell after copy | Excel Programming | |||
Moving a row based on content of a cell to a diff worksheet | Excel Programming |