appending data
 

Hi, I have an excel file with several tabs (tabs A-E) of client data
for each city, plus an additional tab (tab F) with data which I need
to append to these tabs (in tab F, column B stores the city which each
row of data belongs to). The workbook already has a macro that
calculates subtotals for the client data for each city. What would be
the formula to automatically append the data in tab F to below the
respective tabs A-E subtotals?

Thanks!

appending data
 

Let us say Tab F has five columns
B- City Name and C-F data for that city
Further suppose you have City name in Col A in each city say in A100
then you can get col C-F in each tab if you enter
=VLOOKUP(A100,F!A:E,2,False) for Col C value
=VLOOKUP(A100,F!A:E,3,False) for Col D value
=VLOOKUP(A100,F!A:E,4,False) for Col E value
=VLOOKUP(A100,F!A:E,5,False) for Col F value

Note that you need to change only the column index

"mtzc" wrote:

Hi, I have an excel file with several tabs (tabs A-E) of client data
for each city, plus an additional tab (tab F) with data which I need
to append to these tabs (in tab F, column B stores the city which each
row of data belongs to). The workbook already has a macro that
calculates subtotals for the client data for each city. What would be
the formula to automatically append the data in tab F to below the
respective tabs A-E subtotals?

Thanks!

appending data
 

Thanks very much!

All the best