Link to home
Start Free TrialLog in
Avatar of leebaskin
leebaskinFlag for United States of America

asked on

Excel sheet to sheet column copy.

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.
Avatar of leebaskin
leebaskin
Flag of United States of America image

ASKER

logically....

if there is a way to count the rows and only copy that number of row data over to the column in the reports sheet. without going all the way to the bottom and causing the excel to lockup.

hope this helps, Thanks.
Avatar of Glenn Ray
You can count the number of items in a column like so:
=COUNTA(Input1!A:A)
If there's a header row, you'd subtract one from this to get the number of used rows.

However, I'd still like to know how you're wanting to consolidate this data.  If the data layout is the same for all three input files, couldn't you just insert them into the same sheet, one following the other?

An example file would certainly help.  

-Glenn
Yes, I know how to count a row.

I need to: count column > take that number and only copy that much data into a column in another sheet.
Sorry, I didn't mean to sound snappy above.

The data is not the same in all three documents. the first document is used to create the other two, then all three are used to create a report based on the three.

it sounds more complicated then it is. I am trying to have the report auto populate with information from the input files.
From the dynamacy of your inputs, I think what you are wanting to do is way too complicated for a macro.

You could achieve what you need plus allow for further expansion with some visual basic code but it would require sample data and an exact definition of the steps from x to y to achieve the desired result.

If you wish to go down this path then by all means upload a sample file. If privacy is an issue then pm me and we can go from there.
ASKER CERTIFIED SOLUTION
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.