Is there a formula for this??

[safetyman]

Ok, the best way to explain this.......
Say I have sheet 1-figures by quarter, sheet 2-figures by termina
1,and sheet 3-figures by terminal 2. I have about 12 columns in use i
all three sheets. I fill in all the in formation in sheet 1-figures b
quarter row 1 column a, b c, etc to column J. Example below-
A B C D E F G H I J
1. XX XXX x XX XX X XXX XX XX Terminal 1

All the figures are for the Quarter and Terminal 1. Normally I woul
copy the entire row 1, Column A-J to the next open row in Shee
2-Terminal 1( The sheet 2 is set up exactly like sheet 1). What I wan
to know: Is there a way I can set up a formula in a hidden column tha
basically says: If sheet 1-firgures by quarter!J1=terminal 1, then cop
sheet1figures by quarter!a1:J1 to the next available open row in shee
2-firgures by terminal 1!, So I can take one less step of copying on
sheet to another out of the process.
Thanks and any help would be greatly aprreciated.
Safetyma

 

[Debra Dalgleish]

Your workbook will be easier to maintain if you enter all the data on
the Quarter sheet, and use an Advanced filter to extract the data to the
terminal sheets when required,

http://www.contextures.com/xladvfilter01.html

or use an AutoFilter to view one terminal's data on the Quarter sheet.
http://www.contextures.com/xlautofilter01.html