tuli.gaurav
New Member
- Joined
- Jul 13, 2010
- Messages
- 16
i need a macro to search data i input in sheet1 range b5 and it will search the data in sheet 2 and after comparing the search criteria it will display the other relative columns data
Well, one way is to use worksheet formulae; the code puts the worksheet formulae on the sheet, the sheet calculates the vale then the code converts the value to a value without formula.thx for ur quick reply.
because i don't want the result to be copy paste special not formula and in addition to my i query i want the lookup result to be edited if required and there should be another button to overwrite that edited data from where the data has been picked earlier.
I hope i m not confusing you. thx in advance