DebtAcquisitions
New Member
- Joined
- May 20, 2015
- Messages
- 21
Hello,
I have been tasked with a project of taking files (csv or excel) from customers containing a large amount of data, none of these files are the same between customers. I have to take the data, extracting some columns and arranging them into a certain format, exporting the formatted cells as csv for another tool to return a report based on that data...
confusing... I know.. I have to then take this report and then format it with data from the original file again before I am done.
I can use vlookup and =sheet<cell> to gather the information but then I have to populate by dragging and bla bla bla.... the data is so large that it crashes excel if I use copy special feature.
There has to be a better way of doing this. has anyone ever had to deal with this level of formatting with excel? is there a program that can help combine these files into a preformatted document?
any help or ideas would be useful to me.
thanks for your time.
I have been tasked with a project of taking files (csv or excel) from customers containing a large amount of data, none of these files are the same between customers. I have to take the data, extracting some columns and arranging them into a certain format, exporting the formatted cells as csv for another tool to return a report based on that data...
confusing... I know.. I have to then take this report and then format it with data from the original file again before I am done.
I can use vlookup and =sheet<cell> to gather the information but then I have to populate by dragging and bla bla bla.... the data is so large that it crashes excel if I use copy special feature.
There has to be a better way of doing this. has anyone ever had to deal with this level of formatting with excel? is there a program that can help combine these files into a preformatted document?
any help or ideas would be useful to me.
thanks for your time.
