Originally Posted by Ashan Ranasinghe

Hi,

I'm new to this forum and so I'm not sure if this is the right place to post this but i need help.

my problem is i have a few excel documents lets call them
Jan.xlsx
Feb.xlsx
March.xlsx

all of them will have 3 columns
index
customer name
payment amount

now what i want to do is have another excel file called


revenue2011.xlsx

this will have the columns
Index
Jan
Feb
March

the data in the revenue2011.xlsx should be taken from the Jan, Feb and March files without duplicating the index numbers. the data that will be extracted are the "index" and "payment amount"

is there a procedure or formula i can use that will do this.

thanks again