populating cells

  1. V

    Struggling with data matching

    <tbody> Supplier acc# PO Email address Acc name ALAN03 839766 Alan Evans BLUE01 839777 Blue Seal FIRS02 839888 First Choice EAST01 89999 East Anglian MEIK01 829999 Meiko </tbody> Hi - above is a list of orders (table # 1) where I need to retrieve email...
  2. M

    Run-Time Error when Trying to Populate Cells

    Hello All, I am trying to populate cells with a date that is located next to a cell with the word "Visit." This is my code: lRow = Cells(Rows.Count, "A").End(xlUp).Row Do While True If Cells(lRow, 6) = "Visit" Then sLastValue = Cells(lRow, 5) Else Cells(lRow, 5) = sLastValue End If...
  3. J

    Populating a code field with the description field

    I have a list of codes and I want to populate the field next to it with the description of the code. I have the list of codes and descriptions in another table. How do I match them up?
  4. J

    importing data from tabs

    Hello all, This my my first time using a forum like this so bear with me please. I'm working on a spread sheet to track inventories and sales. I'd like to auto populate new tabls with information from exsisting tabs, ie. product names, formulas and final inventory figures. Is there an easys way...
  5. C

    Populate data based on ranges of other data

    Hi there, I'm new to VBA but not to programming in general. I need to populate a cell based on another cell. So if a cell has $0 - $100, the other cell needs to populate with $.15 and another cell populates with $15. If the cell is $100 - $250, the other cell populates with $.10 and another...

Watch MrExcel Video

This Week's Hot Topics

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