| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I automatically put like data into several worksheets?
I have a worksheet with information that I want to copy automatically into
columns on another worksheet. How do I do this? I got the formula that someone gave out a couple of years ago: =IF(Sheet1!A3<"",Sheet1!A3,"") But I don't know how to use it. When I put this formula into the cell where I want the copying to start, nothing happens, except the cell shows a green upper left corner and the following appears in the cell: # REF ! Does Sheet1 have to equal the name I've actually given to my sheet (I've changed the name of the original worksheet on the tab at the bottom)? Can I start the copying of data on row 3 or do I have to start with row 1? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically updating data between worksheets. | Excel Discussion (Misc queries) | |||
| Automatically update data across worksheets | Links and Linking in Excel | |||
| moving filtered data between worksheets automatically | Excel Worksheet Functions | |||
| Update data automatically among worksheets | Excel Discussion (Misc queries) | |||
| Why is data automatically copying to all worksheets? | Excel Worksheet Functions | |||
Threaded Mode
