pdx_2188
04-13-2011, 01:11 PM
I currently have a worksheet that provides data all over the place. I need to be able to rearrange the cells so they read smoothly across the board.
Example Header:
Part Number Jan(QTY) February(QTY) March(QTY) Description
123456 1 0 0 HP WorkStation
The Description is currently under the Part Number. The QTY's that is not currently in bold are the QTY's I can delete as it duplicates the QTY's acrodd the description line as well.
I think it may need to be something like:
If Range(B:D) is not bold then Delete Row Range(B:D) and Move Row in Column A associated with deleted rows to Column E
Else Nothing
End
This may need a For Each loop I'm not sure. I do have some macro experience, but I have never been great at data manipulation
Any help would be greatly appreciated!
Please let me know if you have any questions.
Thanks,
Jeff
Example Header:
Part Number Jan(QTY) February(QTY) March(QTY) Description
123456 1 0 0 HP WorkStation
The Description is currently under the Part Number. The QTY's that is not currently in bold are the QTY's I can delete as it duplicates the QTY's acrodd the description line as well.
I think it may need to be something like:
If Range(B:D) is not bold then Delete Row Range(B:D) and Move Row in Column A associated with deleted rows to Column E
Else Nothing
End
This may need a For Each loop I'm not sure. I do have some macro experience, but I have never been great at data manipulation
Any help would be greatly appreciated!
Please let me know if you have any questions.
Thanks,
Jeff