VBA help for a complete beginner - Copy and pasting from Excel to Word template

So you want to copy each row where the "D" cell is not blank? Also, please put your code in

Please Login or Register  to view this content.

tags or a moderator will not let people reply to your post.

Hi

Really sorry, I'm new to this and this website. Put my code in tags?

Basically I am wanting to copy the table from the "Populated Table" sheet onto a blank word template. If the table in "Populated Table" has blank rows in it i.e. there are no Operations (Column E - My Mistake) then I want it to be able to automatically omit these rows from the copy paste to the word template.

For example. A switching schedule might have 10 operations in it (rows 1 to 10) but anything after that (rows 11 onwards) will be blank. So I wondering if it doable to be able to omit these automatically without having to change the copy paste range everytime to only include the rows with Operations in it?

Thanks for your help

AM2809

If you go to edit your original post, select your code and hit the "#" symbol (not # on your keyboard, it will be next to Bold, Italic, Underline etc.)

Will you ever have a blank row separated by two non-blank rows? E.g. row 8 has no operation, but rows 7 and 9 do?

Awesome, that looks better.

No. There will be no blank row separated by two non blank rows.

Many thanks

AM2809

Ok you can give this a try

Please Login or Register  to view this content.

Hi

I copy and pasted it into the compiler and it worked great. But then I added another few Operations to the "Populated Table" and now it doesn't seem to be working. In the example attached there are only 9 operations but in reality there could be over 50. This is why I have included a big range for the copy paste (B5:G82).

Many thanks

Andrew

Sorry the formulas pasting blank values is messing with it (didn't realize it was acutally being interpreted as the cells containing 0 rather than nothing). Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

I believe have figured out the problem why it stopped working.

Within the 'blank' Operation cells there is actually the =formula to link it to the output of the table on the "Switching Sequence" workbook. Will this mean that it is being read as a non-blank cell? Are there ways to make ignore the linking formula in the 'blank cells'

Many thanks

am2809

See post above (I figured out the issue around the same time you did). The new edit will work as long as your "operations" are never one character long

Amazing! You've done it. I am so grateful.

If I am ever in Toronto I'll by you a beer.

If I could be cheeky and ask one more question?

Is there a way in VBA to give the pasted table a top border after it has been pasted and the table splits over two pages? At the moment when a table is too big for one page then the border at the top row on the second page doesn't have a top border.

Kind regards

AM2809

I appreciate it!

Sorry I'm really not sure how to do that - I don't use vba outside of excel and outlook, so I'm not sure how to deal with borders in word. If you start a new thread someone should be able to help you (they normally don't want you asking multiple questions in one thread)

Ok I will do that.

Thanks again!

AM2809