leebaskin
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.
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.
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
=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
ASKER
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.
I need to: count column > take that number and only copy that much data into a column in another sheet.
ASKER
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.
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
ASKER
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.