View Single Post
 
Old 07-02-2022, 07:34 AM
jackfruit88 jackfruit88 is offline Windows 10 Office 2019
Novice
 
Join Date: Jun 2022
Posts: 4
jackfruit88 is on a distinguished road
Default VBA code to export data to word with header values

Dear experts

I have fallen in data to transpose from excel to word manually i am in need of vba code help ,

i have set of data which is need to copy first 2 rows only 8 columns A:H paste into word with header point

The data layer segregate as two layer FY 19-20 one row, FY 21-22 second row
first two row copy with header paste into word as vertical
third and fourth row as another segment with header value paste into word
fifth and sixth row as another segment with header value paste into word

Thanks
Attached Files
File Type: docx OUTPUT_RESULT-FILE.docx (22.7 KB, 13 views)
File Type: xls twoheader.xls (34.5 KB, 12 views)
Reply With Quote