| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using multiple sheets
I am creating a main page and would like the rows to copy onto separate
sheets. How do I do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using multiple sheets
In your subsidiary sheets you would have a formula like:
=IF(main!A1="","",main!A1) This will bring the value from A1 of the main sheet, or show a blank if the cell is empty. You can copy the formula across and down for the other cells. Hope this helps. Pete On Oct 2, 12:14 am, Tera wrote: I am creating a main page and would like the rows to copy onto separate sheets. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
| Lookup using multiple sheets and multiple criteria, sorry if 2 pos | Excel Worksheet Functions | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
| Exporting multiple sheets to multiple htm files? | Excel Discussion (Misc queries) | |||
Linear Mode
