I am creating a main page and would like the rows to copy onto separate sheets. How do I do this?
T Tera Oct 2, 2007 #1 I am creating a main page and would like the rows to copy onto separate sheets. How do I do this?
P Pete_UK Oct 2, 2007 #2 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
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
