macro help

[tuli.gaurav]

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

 

[SteveO59L]

What makes you think you need code?

 

[tuli.gaurav]

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

 

[tuli.gaurav]

can someone pls help me on this.

 

[p45cal]

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

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.

What are the formulae, and where do they go?