beginner

  1. C

    Looking to learn a formula to help me with...

    I am extracting data from two different vendors, the data I'm extracting should be the same, however a quick glance indicates it isn't! For example, lets say one file contains a list of 1000 students' names. The other file contains 987 students' names. What's the best way to cross reference both...
  2. A

    VBA Macro shortcut to "paste special formula"

    Hi all! I have been trying to write VBA macro to simulate the keystroke (Ctrl + Alt + v + f) to copy and paste formula from an excel cell. I'm a beginner, and so far I've been able to develop the functionality of copying the formula and pasting it relationally. However, the code breaks if it is...
  3. C

    ComboBox Property will not change value

    Hello, I'm creating a User Form and trying to get the starting position of a Combo Box to be the number of the month. For example since it is currently July I would like the Combo Box to start on position 6. When I try this varToday = Date varToday = varToday - 10 'this is purposeful...
  4. K

    Pop up window when click/double click a cell

    Dear All I have two sheets with some information on skill level of a team and with year of experience. Machine_A sheet is summary of no. of skilled person. Machine_D is sheet of data base. Let us assume i have 10 expert engineer in machine installation category. Machine_A sheet shows no. 10...
  5. B

    golf league schedule 20 teams of 40 players

    new to mrexcel but would like some help putting together a golf league scheduler for a 40 player / 20 team league. 18 total weeks. am new to formulas in excel and a general beginner but use excel daily but not to its full potential. want to learn more. thanks.
  6. L

    Relative cell reference selecting enitre row and entire column?

    Hi all, I literally started learning VBA 3 days ago, using excel-pratique's VBA course but as I'm trying to be thorough I started to make a "dictionary" and I'm writing up the different selections that are possible. Could someone send me a working code for: Select entire Row AND entire...
  7. C

    Improving my skill

    Hello, I joined this forum in 2007. Back around then I took an intermediate excel class and I enjoyed it. My work at that time had me maintaining a couple of spreadsheets. this place was great. I haven't opened a spreadsheet in a decade until earlier this year. Now I'm managing some data on...
  8. M

    Access query - multiple tables but same column

    Hey everyone, I am a complete access beginner so I apologize if this is a no-brainer / a dumb question. I have two tables. One called MasterRepList and MastetTechList. In both of these tables, I have a FirstName, LastName and UserID field. (The MasterTechList calls this field TechID) --...
  9. J

    Excel Beginner Question

    All, I will use column A and B as the columns I want to change: I want to make column A Red if column A is not filled out but column B is filled out. But I want to leave column A White if Column B is not filled out. I have not been able to figure that out.
  10. N

    Good idea? Maybe?

    Hello All, So I joined this forum back in 2016 and since then have learned SO MUCH INFORMATION that has helped me and now I am able to help others that were lie me before i joined here. It has been an awesome ride and I really enjoy it. With that being said I have been thinking about making a...
  11. A

    Run-time error 424: Object Required

    Hello, I am an excel beginner trying to make a UserForm for data entry. I made the UserForm and had it working, then accidentally saved the file as the wrong format and had to make a brand new one. I was able to copy the code and add it into my new VBA with all the same box names, but now when...
  12. HeRoseInThree

    Subtract time

    I am looking to subtract 15 minutes from whatever value is in cell O2 and put that information in P2. Any help would be appreciated.
  13. E

    VBA wont calculate cells during loop

    Hi guys I need help with a VBA program I am trying to write. This is my first ever program so go easy haha. Basically I am trying to calculate a correlation table using VBA rather than by hand. I have a table of values that starts (the corner is in) cell T3. The values go to the right and down...
  14. F

    Help a Newbie with a not so simple VBA Macro

    Hi Guys, I need a program that can read multiple columns from multiple spreadsheets and carries out an action if it matches. I believe though the problem is a bit too complex for vlookup! I need a vba macro that can read the a common column from two spreadsheets to see if they match. Then...
  15. L

    Conditional Formatting Adjacent Cells

    So i have my initial formats done: Column I: Planned date Column J: Revised date (if needed) Column K: Actual Date Both I and J have a format to turn colors based on how far we are for the dates.. (ex: 5/15/30 days) My issue, if there has been a revised date in J, i'd like I to turn white-...
  16. A

    BEGINNER USER: Assigning Values to Letters in Multiple Columns

    Hi, please note that I am a novice excel user, so very explicit directions are appreciated. I am hoping to track students' reading level progression through the duration of the school year with an excel spreadsheet so it can be easily visually represented with a line plot. Fountas and Pinnell...
  17. K

    Passing Arguments

    Very beginner question: what does it mean to "pass arguments"?
  18. I

    Free Excel 2016 Training?

    From where I get free Excel Training from Beginner to Advance level.
  19. E

    Blank cell when a corresponding cell left empty

    Hi all, I'm sure this is incredible simple for someone in the know but as I'm still a beginner I'm in need of some help :) I have recently collected a sheet to measure how long my team are taking to send out free samples to our customers. In Column G is the date the request for a sample was...
  20. E

    VBA help reducing chain of linked cells

    To simplify the issue: I have 4 worksheets in my workbook: "Business X", "Business Y", "Totals" and "Summary". The formula in cell A1 of "Totals" is: ='Business X'!A1+'Business Y'!A1 and the formula in cells A1 of "Summary" is =Totals!A1 I want to cut out the middle man ("Totals" worksheet)...

Some videos you may like

This Week's Hot Topics

Top