Inputting info on one worksheet and having it post on another worksheet by location

[tricxster]

I have a spreadsheet that contains information for different shippin
locations. I have a master sheet where all information is loaded and
have tabs for each of our shipping locations. Currently I input th
data on the master tab then I cut and paste the info to a tab in th
same spreadsheet based on which location it went to. Is there a way t
have the information I input on the master sheet automatically input th
same data on the location sheet for the destination? Say I input
shipment on the master sheet going to Dallas, I would like the info o
the master to automatically show up on the Dallas tab without me havin
to cut and paster it there. Thanks for any help you might provide

 

[Arvi Laanemets]

Hi

One possible solution

On master sheet you have a table like
Location, Date, Sum etc.
where Location is some string value, p.e. "A", "B", etc., and in row 1 are
column headings.
Add a column LocationOrder, so that Location is now in column B
A2=IF(B2="";"";B2 & COUNTIF(B$2:B2,B2))
and copy down - you may have the formula ready for empty rows.

Create dynamic named ranges
Loc=OFFSET(Master!$B$2,,,COUNTIF(Master!$B:$B,"<>")-1,1)
Date=OFFSET(Master!$C$2,,,COUNTIF(Master!$B:$B,"<>")-1,1)
Sum=OFFSET(Master!$D$2,,,COUNTIF(Master!$B:$B,"<>")-1,1)
etc.

On sheet for location "A" you want a table
Date, Sum, etc, with column headings in row1 too.
A2=IF(ISERROR(MATCH("A" & ROW(A1),Loc,0)),"",INDEX(Date,MATCH("A" &
ROW(A1),Loc,0)))
B2=IF(ISERROR(MATCH("A" & ROW(A1),Loc,0)),"",INDEX(Sum,MATCH("A" &
ROW(A1),Loc,0)))
etc.

Copy formulas down for as much rows as you need