| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy updating column to another workbook
Hi,
I would like to copy a column that updates to another workbook. If the field is blank I will like it to copy over as blank. data is on trust workbook, list worksheet sheet cell I9. I want to copy cell I9 to interest workbook field B9. If cell I9 is blank I would like cell B9 to be blank. Can anyone tell me how this can be done? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy updating column to another workbook
Hi,
I assume that you want to program this? I would start by turning on the recorder and doing the steps you want programmed. Then test it and ask for help showing us the code. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Marysam67" wrote: Hi, I would like to copy a column that updates to another workbook. If the field is blank I will like it to copy over as blank. data is on trust workbook, list worksheet sheet cell I9. I want to copy cell I9 to interest workbook field B9. If cell I9 is blank I would like cell B9 to be blank. Can anyone tell me how this can be done? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically updating a workbook from a different workbook day by | Excel Discussion (Misc queries) | |||
| My workbook links are not updating (its 30,000 KB size workbook). | Excel Discussion (Misc queries) | |||
| Updating copy of Macro workbook... | Excel Discussion (Misc queries) | |||
| Auto updating a workbook with data from another workbook | Excel Discussion (Misc queries) | |||
| copy COLUMN from 1 worksheet to another (in a different workbook) | Excel Discussion (Misc queries) | |||
Linear Mode
