Hi,
I have a couple different rows of data for different people. How would I make it so when I enter data for anyone, it automatically goes to a separate sheet with the rest of their info, based on their name. Then anytime I write their name and add more info, it automatically keeps updating it into their name sheet. I believe vlookup is a possibility but I'm not too good with formulas.
Any help would be greatly appreciated.
Thank You
1.xlsx
I've uploaded a sample to make it easier. So I would like all the data besides "BUYER" to transfer over to each individual sheet for each buyer, whenever their name is entered in the BUYER column. So I can see the total of everything, for each person.
Thank you!
Here is an updated one for more clarity. Each row should have the corresponding number/data.
Try this approach.
1. create a helper column, I used W, in Main, and copy this to W4 and then copy down...
=B4&COUNTIF($B$4:B4,B4)
Now, on each sheet in U1, copy this, to extract the sheet name...
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
Finally in each sheet, in A2, copied down and across...
=IFERROR(INDEX(MAIN!$A:$V,MATCH($U$1&ROW($A1),MAIN!$W:$W,0),MATCH(BHARAT!A$1,MAIN!$A$2:$V$2,0)),"")
You can do all sheets at the same time by clicking onteh 1st name sheet, then hold SHIFT and click on teh last sheet. all your sheets are now "Grouped" - what you do on 1 will be done on all. So copy that last formula in Group-mode on teh 1st sheet, and it will be done to all teh sheets
When done, click on teh Master to ungroup, or righ-click any tab name and select Ungroup
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I think I'm either slow, or did something wrong, lol. I did your steps, but the information still doesnt copy over.
see attached sample
thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks