exccelinsurance
New Member
- Joined
- Oct 13, 2017
- Messages
- 2
Here is my story:
I have many tabs, mostly irrelevant, and I am trying to create a workbook that has two parts - hence the tabs- input and output. In the input pages I am actually importing data from a CSV files that vary by rows, columns, and "table titles". I have tried using formulas and VBA codes to that will detect what cells have data, then transfer only the columns of data I want into my "ouput" page whether there is 5 rows of data or 25 rows, but not giving me any blank cells or 0s, if possible. Mostly I just need something that can copy the columns I want and know how many rows have data and transfer only those rather than using:
="Sheet1"A1 - etc
then filling down 20 rows just to be certain I have enough rows even though I may only use 2, or 5, or 15 because I will use this every time I have new data and each time the row changes.
Thank you!!
I have many tabs, mostly irrelevant, and I am trying to create a workbook that has two parts - hence the tabs- input and output. In the input pages I am actually importing data from a CSV files that vary by rows, columns, and "table titles". I have tried using formulas and VBA codes to that will detect what cells have data, then transfer only the columns of data I want into my "ouput" page whether there is 5 rows of data or 25 rows, but not giving me any blank cells or 0s, if possible. Mostly I just need something that can copy the columns I want and know how many rows have data and transfer only those rather than using:
="Sheet1"A1 - etc
then filling down 20 rows just to be certain I have enough rows even though I may only use 2, or 5, or 15 because I will use this every time I have new data and each time the row changes.
Thank you!!
