L
Legacy 286942
Guest
Hello Everyone!
First of all, let me say that I am not the kind of person who doesn't look for a solution before asking for help. If the solution to my problem is already out there then it's well hidden !
I have a document with several spreadsheets.
The first one is my working document (MAINDOC) and the others are my 'references' (for example, Client1, Client2, etc.) In those, I have information that are always organized the same way (ex: A1=Client Name, A2=Client Adress...)
What am looking for is the way to fill some cells in my first spreadsheet after selecting a specific client in a dropping list.
Meaning:
On my MAINDOC, I am selecting 'Client1' in a dropping list in B2, then I want in C2, the value in 'Client1' spreadsheet cell D4.
The dropping list is easy but the cross referencing is my problem.
Hope I have been clear enough. I am not even sure that it's possible.
Thank you anyway for any help you would be able to provide me.
First of all, let me say that I am not the kind of person who doesn't look for a solution before asking for help. If the solution to my problem is already out there then it's well hidden !
I have a document with several spreadsheets.
The first one is my working document (MAINDOC) and the others are my 'references' (for example, Client1, Client2, etc.) In those, I have information that are always organized the same way (ex: A1=Client Name, A2=Client Adress...)
What am looking for is the way to fill some cells in my first spreadsheet after selecting a specific client in a dropping list.
Meaning:
On my MAINDOC, I am selecting 'Client1' in a dropping list in B2, then I want in C2, the value in 'Client1' spreadsheet cell D4.
The dropping list is easy but the cross referencing is my problem.
Hope I have been clear enough. I am not even sure that it's possible.
Thank you anyway for any help you would be able to provide me.
