mohanprabhus
New Member
- Joined
- Dec 7, 2016
- Messages
- 17
I'm trying to write a macro that matches an F Column cell in the with the sheet name and then pulls data from Active sheet and then copies to the exact sheet Name where I want to insert the cell value & create pdf based on the sheet
SHEETNAMEs mentioned below
SamplePDF1
PDFfile2
Excel3
PDF4
When i double click on the SamplePDF1 automatically the cells enter in particular Sheet Name (SamplePDF1) in Given Cell value & data Create a PDF.
<tbody>
</tbody>
SHEETNAMEs mentioned below
SamplePDF1
PDFfile2
Excel3
PDF4
When i double click on the SamplePDF1 automatically the cells enter in particular Sheet Name (SamplePDF1) in Given Cell value & data Create a PDF.
PDFNumber | Client Name & Address | Particular | Total | Amount | Tax | PDF Template |
1 | India, 1234, Karnataka, India | 1000 | 847 | 152 | SamplePDF1 | |
2 | Google, 4321, Karnataka, India | Yahoo | 500 | 423 | 76 | PDFfile2 |
3 | Exce1, 12, Karnataka, India | Beetel | 2000 | 1694 | 305 | Excel3 |
4 | Excelforum.com, 312, India | Aptonia | 1560 | 1322 | 238 | PDF4 |
<tbody>
</tbody>