lalakis
New member
- Joined
- Nov 24, 2012
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Guys, please help! I've been trying to do this for the last 5 hours!
I have an excel 2010 file with two sheets. Sheet 1 has some functions that make calculations like this: Column A is the "input" data, and all other columns make calculations based on column A data. Sheet 2 has some sample data in columns, which i am currently manually copy-pasting to Sheet 1 column A in order for sheet 1 to make the calculations. So every time i want to change the set of data, i have to copy-paste a column from sheet 2 to sheet 1- column A.
What i want to do:
I want to have a specific cell in sheet 1 that will act like this when i manually enter values to it:
If entered value in that cell = A, then copy sheet2columnA to Sheet1columnA
If entered value in that cell = B, then copy sheet2columnB to Sheet1columnA
If entered value in that cell = C, then copy sheet2columnC to Sheet1columnA (notice that the destination is always the same, but the origin of data is based on my input)
etc... so that i just manually enter A, B or C to that specific cell, and it automatically changes the values in Sheet 1 Column 1 by taking data from the sheet 2 column that refers to my input.
If you can tell me how to do this, you have both my warm thank you and my respect.
Thank you in advance
I have an excel 2010 file with two sheets. Sheet 1 has some functions that make calculations like this: Column A is the "input" data, and all other columns make calculations based on column A data. Sheet 2 has some sample data in columns, which i am currently manually copy-pasting to Sheet 1 column A in order for sheet 1 to make the calculations. So every time i want to change the set of data, i have to copy-paste a column from sheet 2 to sheet 1- column A.
What i want to do:
I want to have a specific cell in sheet 1 that will act like this when i manually enter values to it:
If entered value in that cell = A, then copy sheet2columnA to Sheet1columnA
If entered value in that cell = B, then copy sheet2columnB to Sheet1columnA
If entered value in that cell = C, then copy sheet2columnC to Sheet1columnA (notice that the destination is always the same, but the origin of data is based on my input)
etc... so that i just manually enter A, B or C to that specific cell, and it automatically changes the values in Sheet 1 Column 1 by taking data from the sheet 2 column that refers to my input.
If you can tell me how to do this, you have both my warm thank you and my respect.
Thank you in advance