Master Row Delete

[phuser]

I have a workbook that contains 7 sheets, the 1st worksheet contains
database querys, I made multiple so I could
sort they way I wanted it, I have other 6 worksheets linked to worksheet 1,
now if I requery and an item is added
it gets added to all the sheets but if I delete an item the row becomes
blank in the 6 worksheets. I have set the properties
on the querys to add row, delete blank rows but the delete doesnt work, is
there another setting I have to add?

P.

 

[Dave Peterson]

If you have formulas like:
=sheet2!a1
then you're gonna have trouble.

But if you can pick a unique value from each of the sheets, you may be able to
enter those values on the master sheet (not formulas!) and use a formula to pick
out the stuff you want:

=vlookup(a2,sheet2!a:e,2,false)

to retrieve the value from column B of sheet2 when the key value (A2) matches
something in the lookup column (Sheet2, column A).

But if I were you, I'd keep all my data on a single sheet and use
Data|Filter|autofilter and Data|Sort to view different aspects of the data.

 

[phuser]

Thanks for the reply Dave, but I have figured out a much simpler way, if I
group the sheets and delete or insert on sheet1 then all the grouped sheets
do the same. It's not as fancy but it works ;-)

P.