Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
appending data
Thanks very much!
All the best |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Appending Data | Excel Discussion (Misc queries) | |||
Appending data from one WB to another WB by date: | Setting up and Configuration of Excel | |||
Formula for appending data | Excel Worksheet Functions | |||
Appending data with VBA | Excel Programming | |||
Appending data from one sheet to another. | Excel Programming |