match cell

  1. I

    VBA code to paste adjacent cell only when cell pasted to is empty

    Hello. I have this code that compares two columns between two sheets. It matches the values in column J in “Ships” with column M in “Main”. It copies the value 10 cells to the right from sheet “Ships” and pastes it in the 3rd cell to the right on “Main” sheet. However, I need it to only paste it...
  2. J

    Matching, sum and return a value

    Hello! I have just started a new job and trying to get a handle on some new data and techniques, and I could use some help! I need to be able to match a project number in one excel sheet, to another, and return a sum of 2 cells relating to the project number to the original sheet. Basically...
  3. D

    Need list of cell #s to match Cell content

    I cannot figure out how to make a proper formula for this issue.... In Columns A-M, I have of various numbers and text. In Column N I have a list of unordered cell numbers (B20, E12, L60, etc.). I want to make a formula for column O that will display the data associated with each of those cell...
  4. E

    help plz this should be fast and easy for you!!!

    ok i have a sheet that looks like this and all i want it to do is this... <tbody> frist date of birth email jan. feb mar apr may jun jul aug sep oct nov dec eric 1/30/1986 eric86vabeach@yahoo.com *read note* bob 2/15/1990 bob@bob.com *read note </tbody> ok in cell...
  5. E

    How to match a cell value only if value is positive?

    Hello, What formula can I use to match B1 value with A1 only if A1 is positive? In other words: B1 equals A1 if A1>0 otherwise = 0 B2 equals A1 if A1<0 otherwise = 0 Thank you
  6. S

    help please with matching cells in a LOOP

    Hello Forum I am trying to loop through a doc. I want to test/match every item in the column against the first item, then loop and then test/match every item against the second item...and so on... and so on. I can successfully go through one column all the way to the end testing every item...
  7. M

    Need formula that links cell names with corresponding file name in folder

    I have an excel workbook which contains info on all credit notes we issue a month, the colunms are: Date, Credit Note No., Relating invoice, Amount, Reason and Account. I also have a folder (C:\Documents and Settings\My Documents\Credit Notes) which contains all the credit notes in pdf format...
  8. K

    showing values in increasing order

    I am using =INDEX($A$1:$R$1,MATCH(MIN(A7:R7),A7:R7,0)) to find the minumum number in the array. How do I display the value one position greater? I need to order the numbers and titles in increasing order. also any way to ignore the 0 vakues in the cell in the MIN function?
  9. M

    Search for range for sumif

    This is a complicated SUMIF that I am struggling with, I am trying to search for the term "TOTAL" in a worksheet (e.g. E14, E25, E36, E41 all have TOTAL), that will then give me the addresses of all these cells as a range for another formula within the same cell. Using this range, I then want to...
  10. O

    Excel VBA find, match and append worksheet values?

    On May 11th, 2008, 06:38 PM, MrExcelMVP "Fazza" provided an excellent code in response to a request by "gravy679" titled "Match and replace cell from another sheet": http://www.mrexcel.com/forum/showthread.php?t=318911 Sub test() Application.ScreenUpdating = False Dim cel As Range For...
  11. D

    Insert Cells / match columns

    Is there a way i can automatically insert cells to match the columns contents. below is what I'm try to achieve. hope you can help!... http://www.djt100.co.uk/before.html http://www.djt100.co.uk/after.html

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top