sheet 1 cell a1 automatically fill to sheet 2 cell a1

[marcmts]

hi all new to forum & excel

need help with automatically have reference from one sheet to another, i already have the item copying over the information from one sheet to another.
my problem is i would like to add to the database & have this automatically go over to another sheet including any formulas in other cells?

Q2 as this maybe way over my head

in database i would like to keep building the sections & moving them across to the other sheet, but on another sheet if the value is 0 in the second sheet it would remove it from the 3rd sheet?
would be happy to work this out from sheet 2
cell a1 = 10 then sheet 3 cell a1 = 10
cell a2 = 0 in sheet 2 then this would be removed in sheet 3 (just taken out of list)


any help would be appreciated ?

 

[marcmts]

this is what i am using at present works ok, it is when i add another line to the database sheet is does not go across ?

='Price Database a'!B7

also tried: =IF(price database a!B6="","",price database a!B6) not sure if this is what i need or not & i had a warning using this #name

 

[keithmct]

try this:
=IF('price database a'!B6="","",'price database a'!B6)

 

[marcmts]

Hi Keithmct

many thanks for change in formula, it worked & removed a 0 if nothing in the cell.
if i then add another row in sheet 1 it still does auto add another row in sheet 2