nicksinthemi
04-04-2012, 05:52 AM
I have a non-automated solution for my problem, but to do this i need to copy two formulas down 3000 rows. Ca someone show me how to automate this process?
The problem is quite simple: in a two column table import from word to excel, sometimes the page breaks create extra rows. I get nothing in the left row and the content in the right is split over two cells. So far, this is my semi-VBA solution:
1. i use an if command to concatenate the right cell to the one above if left cell is blank
2. i use another if command to insert a # marker in column C if the left cell is blank
3. i run a VBA command that deletes any rows containing a #
Can someone explain how i automate the process of dragging a formula down thousands of rows or do I have to render it in offset or something like that... ???
The problem is quite simple: in a two column table import from word to excel, sometimes the page breaks create extra rows. I get nothing in the left row and the content in the right is split over two cells. So far, this is my semi-VBA solution:
1. i use an if command to concatenate the right cell to the one above if left cell is blank
2. i use another if command to insert a # marker in column C if the left cell is blank
3. i run a VBA command that deletes any rows containing a #
Can someone explain how i automate the process of dragging a formula down thousands of rows or do I have to render it in offset or something like that... ???