1. A

    Need macro that Populates usage end date in column T

    Dear All, Please see below image, i have this job i need to do this manually everyday, if this can be automated it makes my life easier. I need macro that Populates usage end date in column T i hope i made instructions clear in Image, if anything more reuired please ask. Many Thanks for your...
  2. E

    Autopopulate sticker template

    Hi, I have a sticker template made up of 6 stickers that I'd like to copy the part number and its descripton from a second worksheet which includes list of part numbers. My challange is I want to auto populate sticker content on template with xls functions depending on number entry "for number...
  3. C

    AutoPopulate Records Based on Dates

    I have a budget forecast workbook where I track my upcoming recurring bills along with all my transactions - be it cash, ATM, check, etc. This also includes any deposits. It is basically an electronic check register with a budget forecast function. There are three ways I gather/enter data: 1)...
  4. H

    Populating 1 row in workbook B from 2 alternating rows in workbook A

    Hello all, Does anyone know how to auto populate 1 row in excel (Workbook B) from information contained in 2 rows in a separate spreadsheet (workbook A)? Workbook A auto populates daily from a google doc form and workbook B is used for accounting (inputted manually). Do you know how to make...
  5. S

    Autopopulate column after dropdown?

    I have a list of states and their counties. I'm looking for a method to choose a state from a dropdown and a column of their associated counties appears. Or, if the user types in the 2 letter state name and it auto populates the counties. I've played around with dropdowns and v/h lookups with...
  6. W

    PLEASE HELP--- Double Click Macro Troubleshooting

    Hello, I'm trying to figure out a Macro so that if I click (For Example) where it says "Double Click" it will copy the Student # in "A4"(in Red) to "C9" AND copy the Date in "C1" (in Green) to "C8". What I would like this to be able to do is, if i double click anywhere in "C2:E6" it will...
  7. D

    Automated alphabetical drop-down list in VBA

    Hello all, This is one of my first posts, so please let me know if I'm not doing it correctly! I read the forum manual but still, I am human and I make mistakes.. My previous post was approved so I hope this one will be as well. So here it goes.. I have a userform which can copy specified...
  8. P

    Drop Down box in Userform to autopopulate a list from sheet14

    HI Please can you help me i have a dropdown box in a userform and sheet14 i have a list of names, in the combobox named 'MTBox' i want this to autopopulate with the names in Sheet14, i have done the following code below that i found on the internet but this doesn't do anything, no errors or no...
  9. D

    Autopopulate cells based on a list in another worksheet

    Hi all, First time poster, long time user. Could somebody please help me with a macro that I would be far out of my depth with, and would help me save a plenty of writing long words in the future. I deal with a lot of plant samples from day to day and about 10,0000 need to be entered over the...
  10. E

    Error Code 9 while trying to auto populate excel sheet

    So this is my code: Dim src As Workbook Set src = Workbooks.Open("UMF_IR_ADM_<wbr style="font-family: arial, sans-serif; font-size: 12.8px;">SPARTACUS_1910 (Data as of 3-5-2018)") Worksheets("Executive").Range(<wbr>"D7").Value =...
  11. M

    Why doesn't my table update consistently?

    Hi, I'm working on a workbook that has an index sheet on it the displays certain data elements based on data on the other worksheets. The issue I am running in to is that my table doesn't always update with all of the data consistently. It is like my For loop is ending early and I can't for...
  12. M

    Auto fill a company name based on the letters in another cell.

    When I export phone numbers from my contact data base it does not include the company name, it only contains the company abbreviation code. My thought is too match the abbreviations with the correct company names in sheet 2 and then insert a blank cell beside the abbreviation in sheet 1 and auto...
  13. O

    Autopopulate Dates for a certain Range

    Hello, I am stuck on how to get this task done. I need to fill in the date automatically across the rest of the table by finding the last blank cell in the row, referencing the the cell before and filling the table to the last column. So in the example below F1 has a date and I need to fill...
  14. E

    Autofilling rows into new tab based on multiple criteria

    Hi there, I was trying to search through old forums and am really close to getting the answer I need but haven't quite found the perfect solution and am now turning here for help. I have column C in sheet 1 that currently populates only if somewhere in that row has the word "fail" or "hold"...
  15. R

    Setting for auto-populating formulas 'invisibly'?

    This is my first time posting a question, because I've always been able to find pre-existing answers in the past - thank you! My issue is hard to describe but I'm sure the solution is maddeningly simple: I have a spreadsheet with data in Column A, and a formula that references it in Column B...
  16. DPChristman

    VLOOKUP Head Scratcher

    I have an odd situation. One of my forms contains a VLOOKUP to a spreadsheet containing employee information. Enter the employee ID #, and the employee information is automatically populated. This is repeated about 10 times on the form, so you can enter the employee ID for up to 10 people...
  17. D

    Auto population issues!!!

    Hi all, I am trying to create a formula that will automatically pull someone's name from a list depending on what code is listed under a specific day. The catch is the formula result has to be consider the day of the week and the time of day (AM or PM) that is selected in another cell. For...
  18. X

    Help to populate table based on data from a different table

    Hi, I am looking for a way to populate a table in excel using another table that is populated manually and a table used for a lookup function. When the user enters a number (Priority Level) into the “summary table”, I would like excel to look at the corresponding skill (Tax, Bens etc) and...
  19. P

    VBA and autopoulate

    Hello, have a farily large database of around 2000 people, sheet1 has all of their names and relevant details. Sheet 2 has data pulled on from a site. I would like the data from sheet 2 to auto populate the cells in Sheet 1. Also if the person does not exist in sheet1 to highlight the data it...
  20. J

    Automatically Convert all columns to a named list column based on the first cell data but incorporating all data in the column as part of the named c

    Hello All, I am trying to put together a spreadsheet that will be, pretty much automated, after importing data from another sheet. I am currently able to Sort the Data based of the import to other sheets based on the first column data which for this case is City. But the issue I have, is the...

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
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 "".
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