VBA help selecting excel rows with data and exporting to word

[crvazquez954]

Hi,

I have a spreadsheet I am preparing for my boss that requires me to review column B (B28:B47) on the "Summary" sheet, determine which rows have data and transfer a portion of the rows (columns B, C, D, E & F) to a word template called "Proposal". I have limited experience with VBA but I know I need a macro code in order to do this. Can anyone help me write an easy code that does this for me? I appreciate any help.

Thanks

 

[DanteAmor]

Dante you are awesome!!! With your help I was able to tweak it and get it to work perfectly. I adjusted the line in the "For Each" statement to read:

"If WorksheetFunction.Count(r) = 0 Then r.Hidden = True"

I then recorded a macro to remove and restore the formatting and added it before and after the "For Each" Statement. I also added a statement near the end of the code to restore the hidden rows. Below is a copy of the code to help anyone else who may have the same issue.

I´m glad to help you. Thanks for the feedback.