How to make this?

March 30, 2011 at 13:33:55
Specs: Windows XP
If text (Sheet1) inside of A1 fild is same as one of the names of sheets (Sheet1) than take info from that sheet (Sheet1) and from fild A2


See More: How to make this?

Report •


#1
March 31, 2011 at 13:55:40
Sorry, not sure I understand what you need?

MIKE

http://www.skeptic.com/


Report •

#2
March 31, 2011 at 15:22:46
Hello Mike
Sorry my english is not so good :(

I will try again

If i have data inside Sheet1 Sheet2 Sheet3 and on Sheet4 i am colecting data from first 3 Sheets. I don't like to have all 3 sheet data in same time inside of Sheet4. But more to can tell to Sheet4 to go to sheet1 or 2 or 3 and to colect data.

If i put inside A1 fild (from Sheet4) Sheet1 (this need to be text - someting like option to be added by me) and inside A2 fild i add something like =A1!D1 (if i need to relink all filds i will make it like this =Sheet1!D1 - but i don't like to do all this manuali but more that sheet4 is created by him self)
This is more that from A1 fild Sheet4 can reconized that he need to go to one of the sheets and colect data.

A B C D
1 Sheet1
2
3 =A1!D1
4
5
I hoppe that this is better :(

Kind regards
Elvir


Report •

#3
March 31, 2011 at 17:44:09
If you have just one or two cells that need to be copied then you could use a =VLOOKUP()
but if you need a large number of cells or whole rows of data to be copied then you will need VBA code, which I cannont do.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question