Forum Discussion
Solved
Help regarding extracting data
I have data on a sheet, which contains table which have 1)an item code 2) name of item 3)calculation in a tabular form 4)unit of measurement of content 5) its computed value I want to sepera...
- I will defer to the greater expertise of others. From what I see, however, I think a total redesign is in order. There's just no consistent or systematic use of Excel's abilities to retrieve data from a database table. Users are simply (from what I could see) entering a cell address in Sheet 1 to fill in a cell in Sheet 2....I didn't look at every cell, but what I did see showed no evidence of using INDEX, MATCH, VLOOKUP, or any of the other commonly used methods to manipulate data.
So as I said, I'll defer happily to others if they can make a useful suggestion beyond "redesign"... And I apologize for possibly raising your hopes prematurely.
greetings and thank you sir for taking out time and replying to my query. i will send the original files here sheet 1 contains the data we are provided, which is fed into sheet 2, calculations are made in sheet 2, and the data is computed, the data I want to segregate is fed into sheet 3, the data in sheet 3 is used for making estimation of various works like construction of buildings, bridges, protection works etc. Now data is collected in sheet 1 from market survey, and as they change so the values in sheet 2 and sheet 3, now i want to use this segregated data to fill it in sheet 3. i hope you get it, sorry for inconvenience caused
I will defer to the greater expertise of others. From what I see, however, I think a total redesign is in order. There's just no consistent or systematic use of Excel's abilities to retrieve data from a database table. Users are simply (from what I could see) entering a cell address in Sheet 1 to fill in a cell in Sheet 2....I didn't look at every cell, but what I did see showed no evidence of using INDEX, MATCH, VLOOKUP, or any of the other commonly used methods to manipulate data.
So as I said, I'll defer happily to others if they can make a useful suggestion beyond "redesign"... And I apologize for possibly raising your hopes prematurely.
So as I said, I'll defer happily to others if they can make a useful suggestion beyond "redesign"... And I apologize for possibly raising your hopes prematurely.
- Please don't applozize, I appreciate you, thank you
Regards