Code from tigeravatar ,Copying data from one sheet and copying it
I want to look at column C and i have 3 values in there and dictate where i pull the data into the 3 different Templates. ( apples goes to template 1, Oranges goes to template 2, and Coconuts goes to template 3 )
tigeravatar got me this far. any help will be appreciated.
Daniel
Please Login or Register to view this content.
Someone may be able to help without one, but if you can upload a workbook, I believe I can figure this out.
A VBA novice, excited to learn!
Template1 will be peach, template2 willbe oranges, template3 will be Apples, Template4 will be Grapes. I want to use the primary data ( Fruit ) to go to a differnet Tempalte. The macro i use will pull the data that i need , I just want all the peach to go to peach Tempalte and Apples to go to Apple template and so on.
[ATTACH]198283 [/ATTACH]
Please Login or Register to view this content.
Last edited by JBeaucaire; 12-07-2012 at 01:11 PM. Reason: added missing [/CODE] tag
DanielRay,
Your posted example workbook has the fruits in column E when your original post said to look in column C. Also, the posted example workbook doesn't have a sheet named Template1, only Template2 through 4, and a sheet named 'Solo' with some prefilled information. Basically, it's confusing.
Do you want to split the data in the 'Names' sheet based on the entry in column E (in this case, the fruit)? Does each row get its own sheet, or should all "Oranges" go into a single sheet based on 'Template2'? What data in the row goes where in the template?
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hey tigeravatar
I uploaded the file now. When you look at the sheet where the data is going to be pulled from you will see the fruit column. I want to search by the fruit first and put the that info into the appropriate sheet ( Apples, Peach, Oranges, Grapes )
the left over data that will be pulled will be the same on all the other sheets. I would like to also have it create the new worksheet with the name of the person. For example if it has a grapes use the grape template but great the new sheet with the name. I hope i explained it clearly. Let me know if I didnt.
ForumQuest.xlsx
The name is col B
Just realized we wouldnt need the sheet named Template1. Do you agree?
oh and The fruit will go in E2 on all the templates
This what i have so far, Doesnt work but on the right direction.
Please Login or Register to view this content.
DanielRay,
Because each "template" sheet seems to be 100% identical, I don't see why you need 4 different ones instead of just one sheet named 'Template'. Here is a code that you could use for that. I wasn't sure what cells in the row go where on the template, so I only filled in a few:
Please Login or Register to view this content.
I wil be adding a bottom part later. for example if the fruit is apples it will go to the apples template where it will have everything about apples( recipies , history of the Fruit, and so on ). the part i want to auto populate
is just gonna be the info part. I may have 10 people wanting apples and 3 wanting Grapes. I will be wanting to create a new sheet according to the fruit tempalte but will have their last name,fist name as the new sheet name.
In that case...
Please Login or Register to view this content.
This is SOLVED ! Thanks tigeravatar!!!
Last edited by DanielRay; 12-07-2012 at 03:13 PM. Reason: Wording
This line:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks