• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • Last Modified:

Automated form in excel

Hello,

I am trying to generate a basic letter using data from another spread sheet within the workbook. I’ve found code from contextures that is pretty much what I am looking for. However I can’t seem to work out what the code is doing.
Can someone please have a look and let me know how I go about manipulating the code in such a way that it gives me the data I need?

examplev1.xlsm
0
vegas86
Asked:
vegas86
  • 2
1 Solution
 
Curt LindstromCommented:
See modified file which attempts to clarify how the macro works. The easiest way to make it work the way you want it is to modify the "finalists" worksheet to only have data in the columns you want to transfer to the "No letter" worksheet.

Regards,
Curt
examplev1-mod1.xlsm
0
 
Curt LindstromCommented:
Say you only want to see the shop and the address data. Then you can modify the first sheet like seen in this attachment and adjust the code accordingly.

Curt
examplev1-mod2.xlsm
0
 
vegas86Author Commented:
Just tried it and it works perfectly!!
Thank you Curt!
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now