kingconsto
New Member
- Joined
- Apr 19, 2017
- Messages
- 32
Hey guys,
I am trying to write a macro that will copy all the cells in a column only if the values are not N/A. For example in column A I have,
Data
Data
n/a
Data
Data
Data
n/a
Data
I would like to copy the 6 cells (example only, could be 6 or 8 or more or less) that have data and paste it in column Z. I would like to code to loop and do the same for column B. The data in column B should continue down the list in column z after all the data from column A. So essentially
Column A Data
Column A Data
Column A Data
Column A Data
Column A Data
Column B Data
Column B Data
etc.
Thanks for the help!
I am trying to write a macro that will copy all the cells in a column only if the values are not N/A. For example in column A I have,
Data
Data
n/a
Data
Data
Data
n/a
Data
I would like to copy the 6 cells (example only, could be 6 or 8 or more or less) that have data and paste it in column Z. I would like to code to loop and do the same for column B. The data in column B should continue down the list in column z after all the data from column A. So essentially
Column A Data
Column A Data
Column A Data
Column A Data
Column A Data
Column B Data
Column B Data
etc.
Thanks for the help!