| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need macro to copy a list of named cells between worksheets
I have a workbook containing a worksheet that has a bunch of company info and
another that contains new info to replace the old info. Cells on each sheet are in different locations, but are named and I have a table of from/to names off to the side in a worksheet that I update occasionally when new info is added. How do I write a macro that will copy all of the FROMNAMES column cell name contents to the corresponding cell name in the TONAMES column? .... X Y .. 22 FROMNAMES TONAMES 23 newcompany company 24 newcontact contact 25 newphone phone 26 newfax fax 27 newemail email |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy and pasting a find all list into another column | Excel Discussion (Misc queries) | |||
| Macro Help In Excel | Excel Discussion (Misc queries) | |||
| Macro help - copy a cell down | Excel Discussion (Misc queries) | |||
| Macro to copy cells | Excel Discussion (Misc queries) | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
Threaded Mode
