Hello,
I need to create multiple standard forms with data that I fill in on a separate tab.
On my Entries tab (from attached file) , I enter various information in (Jim Jones, Mary Smith, Adam King).
These entries need to be put in my BSM tab (has to be in this format) and I need one for each entry. BSM tab for Jim Jones, separate BSM tab for Mary Smith, etc.)
Sure there is VBA logic out there somewhere. Any help would be greatly appreciated.
I wonder if there's an easier way then using that second For loop to fill the values, but nothing immediately comes to mind since you have to skip every other row on the form. Anyway, my testing shows this working as expected.
Please Login or Register to view this content.
Last edited by walruseggman; 01-19-2016 at 02:25 PM.
I'm interested in starting a career working with VBA, if anyone knows of any opportunities!
Enter 1 into C3 of the BSM sheet and run this macro.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Here's my effort. I added a test for existing worksheet.
Please Login or Register to view this content.
David
(*) Reputation points appreciated.
Thanks for all the great responses!!!
This does help me out, but is there a way to match up the columns accordingly based on the row name from the 1st tab?
For example the name columns on the first tab might be in another column, but the format on the second tab will remain the same. So I would need to match up the columns accordingly.
Appreciate the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks