Hey guys,
Sorry if this is really simple, but I have literally been up all night trying to get this **** macro to work.
What I have is am Excel spreadsheet, and a Word Document, I have set up a macro button.
I have 4 columns in excel - B20, C20, D20 and E20 - that I need to copy onto the word document. The big issue is it needs to stop when there are no values. Sometimes I will have 2 rows in those columns, sometimes I will have 70.
These columns need to go under a picture that I have on file, with the single cell, D15 also on the word document below everything.
I also what the document to then save and close...
Please help me...
Sorry if this is really simple, but I have literally been up all night trying to get this **** macro to work.
What I have is am Excel spreadsheet, and a Word Document, I have set up a macro button.
I have 4 columns in excel - B20, C20, D20 and E20 - that I need to copy onto the word document. The big issue is it needs to stop when there are no values. Sometimes I will have 2 rows in those columns, sometimes I will have 70.
These columns need to go under a picture that I have on file, with the single cell, D15 also on the word document below everything.
I also what the document to then save and close...
Please help me...