Okay so I I'm looking for an easy way to add one column of data from 1 work sheet with another column of data in a second work sheet to come together in a third work sheet.
I'm aware of using ='[Filename1.xlsx]Week 1'!$F$4+'[Filename2.xlsx]Week 1'!$F$4 and changing the 4 to 5, than 6. Then once reached the bottom starting again for the next column. ( changing F to H for example ) This is very tedious and hoping someone can shed some light on how I could do this using autofill.
If anythings unclear just say so and I'll try clear it up more
thanks, lee
Bookmarks