macro help

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
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

tuli.gaurav

New Member
Joined
Jul 13, 2010
Messages
16
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
 

p45cal

Well-known Member
Joined
Nov 10, 2009
Messages
4,763
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?
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,403
Messages
5,511,150
Members
408,828
Latest member
Csmnvld

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top