populate worksheet

  1. L

    Populate Rows of Data into new spreadsheet based off one cell value

    I have a Master spreadsheet that consists of customer information (columns A - Q are headers such as First Name, Last Name, Source, Phone Number, etc) and the rows are the customer's information. In column K, we define which sales associate these customers were assigned to by name (Ted...
  2. B

    Populate Excel Worksheets with data from access

    I have a access database with tbl's, and qry's etc., and a Excel spreadsheet with 30 or so worksheets. ex. (02), (04), (06) and so on. Each worksheet represents a specialty. What I'm trying to do is have access open the spread sheet grab data from a tbl in access, match the cmsspecialtycode with...
  3. U

    Trying to use specific text strings in A:A to populate something else in B:B

    Hi. I've tried using VLOOKUP, but I guess that didn't work because I need full values and not parts. Column A has text that I need to transcribe into Column B as a specific Category. For instance, for every time "RX" appears in column A (not standalone necessarily) I need Column B to write...
  4. T

    Populate 65k cells from Access

    Any ideas on what would be the best option to populate 65k cells in excel from access? So far I have tried to options. First, import all relevant rows to separate sheet in same file and access these with vlookup. Works, but i get the feeling that not as elegant solution as it could be...

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
Back
Top