LinkBack URL
About LinkBacks
I don't want to waste time thus
I want to pull data into the attached
sheet , the seller name being on column a
of each sheet and the his sales profit on
column D
22 sheets means JAN 2013 data to JAN 2014 Oct
I don't want to waste time thus
I want to pull data into the attached
sheet , the seller name being on column a
of each sheet and the his sales profit on
column D
22 sheets means JAN 2013 data to JAN 2014 Oct
You provide 1 sheet with some names down the side and some numbers across the top, and nothing else. You will need to provide more data than that, and some sample answers would help as well - make sure your data is realistic, without using sensitive data
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
Here is sheet1 test data
Then I have sheet2 , sheet3 going upto Sheet22
and where does the seller name come in?
Fdbibbins those marked x x x xare sellers , you can copy seller1 seller2 and so
there for testing , these sellers may not be in the same row on every sheet ,
there are new people we have hired and some fired and so on
I want to do formula on b2 and drag right and down
The seller name will be on column A every sheet
Maybe i have to do 22 times for the first row , is that the trick
or there something else without doing it 22 times just for once
You apparently want the extract based on the seller's name and the sheet, yet you dont provide a range of sellers names?
If you want help, you need to provide the necessary data for us to help you, we cant/wont guess at what you want and what you are working withI want to pull data into the attached
sheet , the seller name being on column a
Yes seller name and the amount , definately the range selection of
sellers will be important to find where the data is , in another words
I am avoiding to VLOOKUP 22 times
OK if your names are always in the same order, use this, copied down and across to pull in column B data from each sheet...
=INDIRECT("'sheet"&B$1&"'!B"&ROW())
change the bolded part for each column you want
Note also that this is based on your sheet names being sheet1, sheet2 etc
Yes almost there , the names are no in the same order
Thus you will only need to modify the formula a little bit with that beautiful & combo
that i don't know to write
If it pulls correctly find attached I have attached 2 sheets
with seller1 in different positions
Im not guessing at what you might have. Provide realist data, in sufficient quantities for me to work with.
If you cant do that, then perhaps another member would be willing to help you further
Maybe this wil work?
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
popipipo thanks , I am glad I don't have to do it 22 times
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks