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.
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
Regards