auto populate

  1. G

    VBA Nightly Process Run

    I have an excel spreasheet where I would like to run a Ctrl+Shift+R in three seperate tabs at 9:00 PM every night. Does anyone know if that is possible? I am not a VBA user by rights so if you have a solution, please treat me as a novice. Thank you Kindly, Matt
  2. G

    I want to write a comprehensive program... I think

    Hi all! I have a question that is somewhat general, I'm really looking for a starting point, or a thread that can help in more depth. I do consulting work for golf courses - my background is in turf - and as part of my consulting, I often "build" chemical and fertilizer programs for use by...
  3. P

    populate cells in new "log" worksheet from three separate worksheets used as different invoice templates

    Can anyone advise..how I can create an ongoing "log" to automatically populate inv#, date, customer, and amount, pulling data from three other worksheets using identical templates (for 1st, 2nd and final invoices). Since they are only templates, every time I create a new customer invoice by...
  4. A

    Hi, How do you populate a chart from other cells

    Hi I'm a rank amateur and I'm trying to work on something for leisure. its a Rifts Initiative chart for my role playing game. What Id like it to do: it takes the dice roll of the initiative (1-32) the divides that by the number of attacks (1-15) to get the exact initiative segment that the...
  5. C

    Auto Fill cells from a list onto another sheet

    I actually have a couple questions here now. First, I have a user data base on one sheet with contact information that is all on one row and I am trying to copy select data from the data base onto an order form. I have a drop list box to select a name on the order form and I want the contact...
  6. J

    Two dates and text in one cell

    Hello everyone, This is my first post. I've used this web forum for almost a year now. It's really helpful. Helped me finish my MBA and helps me with my current positions as a data analyst for one company and as a business consultant for another. So, thank you. -- Hello everyone, Two dates...
  7. M

    Validation lists needed to autopopulate, or not

    The goal is for efficiency. The user wants to have the options to: 1. Select component-by-component or, 2. Select a kit. In 7 of 10 times, a Kit is going to be ordered. My thought is to add a dropdown list in Column F that offers: - Component - Kit A - Kit B - Kit C If "Component" is...
  8. J

    Populating row of cells after drop down selection

    Hello, I am using win7 64 and Excel 07. I have 2 sheets of data. Sheet2 is a table listing data in rows for a column of 20 different items. Each item has 19 different values associated with it (if that matters). On sheet 1, I want to create a similar smaller table with 5 drop downs that...
  9. E

    Current cell value into comment

    I am wanting to know if it is possible to automatically put the current cell value into an existing comment on that cell. I have an auto populating excel sheet in my workbook that has comments on all the active cells. The existing comment looks as follows: #### Text Text #### Each comment is...
  10. C

    Auto Populating cells form a different page

    Hi Guys, I hope someone can help me... PLEASE!! I have a list of names in column A and depending on what name I select from that list it will populate cell "a1". Now depending on what name is in cell "A1" I would like it to reference a different page and auto populate the information that...
  11. M

    Auto Populating Using Macro

    Hi I'm hoping that someone can please help me. I have a spreadsheet with x2 tabs and I have imaginatively named them "1" and "2". On tab 1 there is a table Column A represents the "Name" & cells A2-A5 have names in I.e. Mark, Paul, Adam and Cy Cells B1 & C1 have been merged and have the...
  12. J

    Macro: open files in multiple folders and run defined macro

    What I am trying to accomplish is have a macro that runs from "personal" searches through multiple folders and sub folders, which are set up identical for all agents, and runs the predefined macro on each workbook in a folder with a defined name. What I would like the macro to open, run, save...
  13. S

    Auto Populate Cells

    Hi, I have two columns in my spreadsheet - one that lists employeeID and the other lists Employee Name. I am creating a drop down lists so employees can select their manager. I would like for Excel to auto populate the manager's employeeID when someone selects their name. Can someone assist...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top