|
FIND AND REPLACE DATA BETWEEN TWO EXCEL SHEETS USING FORMULA
Hi everybody,
Hey I am stuck up with this one. Can somebody help please. I need to find a value of one cell from another sheet and paste that value using automation (formula). It would be a big task if one were to use the Find and replace comand manually. Thanks and regards gkb |
FIND AND REPLACE DATA BETWEEN TWO EXCEL SHEETS USING FORMULA
Easy, it would look something like:
='Sheet2'A1 That should put the value of cell A1 on Sheet2 into the cell you paste the formula in. Does that help? Or do you need more than just that one cell value? "gkb" wrote: Hi everybody, Hey I am stuck up with this one. Can somebody help please. I need to find a value of one cell from another sheet and paste that value using automation (formula). It would be a big task if one were to use the Find and replace comand manually. Thanks and regards gkb |
FIND AND REPLACE DATA BETWEEN TWO EXCEL SHEETS USING FORMULA
Hi AlieSlavin,
Thank you for your effort. I think I did not explain my problem properly. Example: Sheet1 A B C D E F (Description) (value) (Description) (Value) (Description) (Value) 1 1000H 122.22 1100P 150.00 3333T 100.00 2 1100H 133.33 1200P 160.00 4444T 200.00 3 1200H 144.44 1300P 170.00 5555T 555.00 4 1300H 155.55 1400P 180.00 6600T 600.00 5 1400H 178.88 1500P 190.00 7000T 100.00 6 1500H 198.00 1600P 200.00 8000T 200.00 7 1600H 123.00 1700P 122.22 9000T 300.00 8 1700H 111.00 1800P 144.44 1000T 444.00 Sheet2 A B C D E F (Description) (value) (Description) (value) (Description) (value) 1 1600H 1400P 1000T 2 1700H 1800P 1000T 3 1100H 1300P 8000T 4 1000H 1500P 9000T 5 1700H 1800P 1111T Now I need to find the value of A,C & E and paste in columns B,D & F in Sheet2 from Sheet1. Please note that Sheet 1 comprises of large data and only small part of these data are required in Sheet2. In rare cases, "Description" is not found in Sheet 1 and hence the corresponding result for that particualar cell should be displayed "Not found". Hope I have explained properly this time. Regards gkb "AlieSlavin" wrote: Easy, it would look something like: ='Sheet2'A1 That should put the value of cell A1 on Sheet2 into the cell you paste the formula in. Does that help? Or do you need more than just that one cell value? "gkb" wrote: Hi everybody, Hey I am stuck up with this one. Can somebody help please. I need to find a value of one cell from another sheet and paste that value using automation (formula). It would be a big task if one were to use the Find and replace comand manually. Thanks and regards gkb |
FIND AND REPLACE DATA BETWEEN TWO EXCEL SHEETS USING FORMULA
Hi,
lookup will do what you need Regards Waseem On Dec 7, 10:38 am, gkb wrote: Hi AlieSlavin, Thank you for your effort. I think I did not explain my problem properly. Example: Sheet1 A B C D E F (Description) (value) (Description) (Value) (Description) (Value) 1 1000H 122.22 1100P 150.00 3333T 100.00 2 1100H 133.33 1200P 160.00 4444T 200.00 3 1200H 144.44 1300P 170.00 5555T 555.00 4 1300H 155.55 1400P 180.00 6600T 600.00 5 1400H 178.88 1500P 190.00 7000T 100.00 6 1500H 198.00 1600P 200.00 8000T 200.00 7 1600H 123.00 1700P 122.22 9000T 300.00 8 1700H 111.00 1800P 144.44 1000T 444.00 Sheet2 A B C D E F (Description) (value) (Description) (value) (Description) (value) 1 1600H 1400P 1000T 2 1700H 1800P 1000T 3 1100H 1300P 8000T 4 1000H 1500P 9000T 5 1700H 1800P 1111T Now I need to find the value of A,C & E and paste in columns B,D & F in Sheet2 from Sheet1. Please note that Sheet 1 comprises of large data and only small part of these data are required in Sheet2. In rare cases, "Description" is not found in Sheet 1 and hence the corresponding result for that particualar cell should be displayed "Not found". Hope I have explained properly this time. Regards gkb "AlieSlavin" wrote: Easy, it would look something like: ='Sheet2'A1 That should put the value of cell A1 on Sheet2 into the cell you paste the formula in. Does that help? Or do you need more than just that one cell value? "gkb" wrote: Hi everybody, Hey I am stuck up with this one. Can somebody help please. I need to find a value of one cell from another sheet and paste that value using automation (formula). It would be a big task if one were to use the Find and replace comand manually. Thanks and regards gkb- Hide quoted text -- Show quoted text - |
FIND AND REPLACE DATA BETWEEN TWO EXCEL SHEETS USING FORMULA
Hello,
Thanks, but seems i am making errors, the cell is calculating wrong value. Is it possible to give one example formula in the below case please. thanks gkb " wrote: Hi, lookup will do what you need Regards Waseem On Dec 7, 10:38 am, gkb wrote: Hi AlieSlavin, Thank you for your effort. I think I did not explain my problem properly. Example: Sheet1 A B C D E F (Description) (value) (Description) (Value) (Description) (Value) 1 1000H 122.22 1100P 150.00 3333T 100.00 2 1100H 133.33 1200P 160.00 4444T 200.00 3 1200H 144.44 1300P 170.00 5555T 555.00 4 1300H 155.55 1400P 180.00 6600T 600.00 5 1400H 178.88 1500P 190.00 7000T 100.00 6 1500H 198.00 1600P 200.00 8000T 200.00 7 1600H 123.00 1700P 122.22 9000T 300.00 8 1700H 111.00 1800P 144.44 1000T 444.00 Sheet2 A B C D E F (Description) (value) (Description) (value) (Description) (value) 1 1600H 1400P 1000T 2 1700H 1800P 1000T 3 1100H 1300P 8000T 4 1000H 1500P 9000T 5 1700H 1800P 1111T Now I need to find the value of A,C & E and paste in columns B,D & F in Sheet2 from Sheet1. Please note that Sheet 1 comprises of large data and only small part of these data are required in Sheet2. In rare cases, "Description" is not found in Sheet 1 and hence the corresponding result for that particualar cell should be displayed "Not found". Hope I have explained properly this time. Regards gkb "AlieSlavin" wrote: Easy, it would look something like: ='Sheet2'A1 That should put the value of cell A1 on Sheet2 into the cell you paste the formula in. Does that help? Or do you need more than just that one cell value? "gkb" wrote: Hi everybody, Hey I am stuck up with this one. Can somebody help please. I need to find a value of one cell from another sheet and paste that value using automation (formula). It would be a big task if one were to use the Find and replace comand manually. Thanks and regards gkb- Hide quoted text -- Show quoted text - |
| All times are GMT +1. The time now is 06:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com