using multiple sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a main page and would like the rows to copy onto separate
sheets. How do I do this?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel shortcut options 0
can i automatically copy subtotals in excel to another s/sheet? 1
COUNT rows on external sheet if between date range 3
VLOOKUP with multiple columns or worksheets 1
copied from web page to excel sheet and cant remove from sheet 2
dynamic data copying between worksheets 0
Replacement for multiple spreadsheets 3
use dates to create a summary report 1

Back
Top