I have to create a report from three different csv files. lets say these files are: input1, input2 and input 3.
These three files have a set amount of columns but an unknown amount of rows. (sometimes 50, sometimes 150k+)
each file gets copied into its own tab (input1, input2 and input 3) respectfully.
I need to create a report that pulls information from each input file...
I have tried to do a special copy of each column into the report but the file size gets too large because it copies all the way to the bottom of excel.
I have tried (='input1'!A1) or vlookup commands but it too has to be dragged to the end of the row of data.
Is there another way to auto populate a column?
I hope I have explained this correctly.