| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dealing with Worksheet Names
I'm trying to copy from various parts of a succession of worksheets. Everything is in the same file.
My worksheets are named 1,2,3,4,5 I want to copy the contents from C4 in worksheets 2,3,4,5 into column 3 in WS1; then I want to copy the contents from C6 to column 4. It's been a horror show - I'm dealing with formulas like ='[C3]1'$C$4 and each cell has to vertify the directory & file. Please help... Jim Berglund |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
| MAKE A LIST OF NAMES FROM REPEATED NAMES IN THE SAME WORKSHEET | Excel Discussion (Misc queries) | |||
| Dealing with worksheet groups | Excel Worksheet Functions | |||
| Changing VB Component Names to match Worksheet names using VBE | Excel Programming | |||
| return all worksheet tab names and chart sheet tab names in report - an example | Excel Programming | |||
Threaded Mode
