beginner

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

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

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

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.

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

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

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.

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

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

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

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

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

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

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

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

<tbody> I need help calculating a weighted average rate for a specific value. I know value 226 has a weighted average of 0.33920. How would I calculate this, given the criteria below? Thanks in advance for your help, it is much appreciated. <colgroup><col width="77" style="width: 58pt...

Hello, it will be a stupid question most probably... Why in VBA we are using the following: "If Not Selection.Value > "" If I'm correct that this basically means "if selection value is not bigger than nothing", which mean if value is 0.. There is no "If Selection.Value = "" for this or why...

Basically I'm trying to figure out if the following things are achievable using macros. If it's not possible, I'd greatly appreciate any suggestions you guys might have on work arounds and if it is possible I'd really appreciate any resources you could suggest that would help me learn how to...

Hey peeps, I'm a new Excel user that's used it for quite some time. I've used my own fair share of formulas on Google Docs Excel sheets and calculation that sparked my interest in finding out more complex ways to use it. I know this question may be asked a lot, but I'd like to learn advanced...

I am new to macros and VBA, so please type slowly. I am trying to use a checkbox (true/false) as a trigger element to call one of two Macros (Hide and Unhide a column). When false, I want the column hidden. When true, I want the column unhidden. I will need a total of 9 checkboxes and columns...