Hi,
I have a template sheet which uses vlookups to fill out the required cells when a code is input into cell E9.
The problem is I have 160 templates I need to fill out, I have a list of 160 codes to input.
I have used a macro to duplicate my template 160 times, however is there a way to input a different code into each template sheet? I don't fancy manually inputting them all!
Any help would be really appreciated.
Many thanks
Nicky
It would be great if u provide sample workbooks with desire output
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks