help me

hey guys, glad to know there are wonderful forums for random questions like this. i'm not bad at excel, but my goodness am i ever stumped right now. i have in a workbook (weekending date whatever) MANY sheets (per job) in which i have a list of men's names and occupation codes (Lastname...

Hi, I have an excel project that I need a lot of help with :( I can't seem to grasp nested IF's or VLOOKUPS. Here is the information Product pricing is A1 subtotal and shipping cost are D2 and E2 then the list of product supplies are A3 thru 17 and under worksheet named product prcing and...

Im trying to make a tacker fro all my works training that we do, an example is below, the dates are when they did the training, and theh months are the frequency of the training. A B C D E F G H what im trying to do is use conditional formatting to turn the dates yellow when they are...

the code is to create chart and but name, title, range, style and type for chart the code run well except type and style any idea Charts.Add With ActiveChart .HasTitle = True .ChartTitle.Text = Application.InputBox("Please enter chart Title", "Chart Title", "As of " &...

Hi, I am trying to hyperlink about 10,000 files using VBA as. The following cells contain: B1 = The path to the files to be linked (I named the cell range Path) B3:B10003 = the filenames of all the pdfs (eg. Document1.pdf) This is the code i have done but it isnt working (i am new to VBA)...

I have done numerous searches and attempted different code myself I can't seem to get it to work though and I am hoping someone can help me out. What I want is that when the code is executed it creates a folder for every value in column A and doesn't make repeats. Then Once this folder is...

How to resolve this problem? :confused: If I have a combination of 125x10 in cell A1, then I just need the number after the "x". So, the value in cell B1 is 10. Example: A ____________B 1 125x10 ________10 2 53x5 ___________5 3...

I have this formula for conditional formatting: =INDIRECT("G"&ROW())=3 This works perfectly fine, now i want change colour of cells if 2 different rows contain a certain number, so: Column G = 3 and Column K = 2 or 3 and the rows should be highlighted only if both columns match? Help?

Hi: I've been trying to write a macro to be able to open multiple hyperlinks all at once. Currently, I have to check thousands of URLs, some of which get removed due to copyright infringement on YouTube. My objective is to be able to track those URLs that have been deleted. I found the...

I'm having a problem creating a VBA ADO to call a select statement from a table and display it in the immediate window. (I really have no idea where to start either) http://www.blackbootmedia.com/School/FinalProject.accdb What I need to do is "Create a VBA function to produce a report in the...

Hi, I am new to this forum...but honestly i am loving it...get to learn and implement so many new things...okay now to the porblem that i am facing. Scenario In sheet 1, I have User Name in column D5:D5000 and Date starting APR to Dec in column F5:F5000 in format DD-MMM-YY. Problem in Sheet 2...

Hi Everyone, I can't seem to get a time delay to work. I thought it wouldn't be too difficult but all i want to do is: as part of a macros that is triggered by a calculation result equalling 1, at first cell A4 = 0 and then at the end of the macros, after a 10 second pause cell A4 = 95. Why...

Hello all, I am relativly new to VBA, and I have spent a fair amount of time trying to figure out the following, however it appears that I am stuck! The situation: In one worksheet (sheet 1) I have a column of numbers ex: 3 2 5 In another worksheet (sheet 2) I have a matrix of data...

I am writing a VBA code for a form that places 4 records in a table that is then queried and displayed in a subform. The person would enter some initial information and then click a button which would place the records in the table to be queried. Everything was working fine on the first sheet...

I have used code like this Range("A65536").End(xlUp)(2, 1) = txtrelief.Text before to find the next empty row and have a text box from a form print to that row. This time though I am having some problems. Whatever I type in the text box on the form lets say I type in JimJones it enters the...

Hey Guys, Need a bit of help again, I need to create a report that will look at the time that a group of people are logged in and then based off of how long they were staffed, tell me how many minutes they should be in break and lunch. Ex. If an employee is logged in for 2Hrs 10min they get...

I have a macro that sets a range named FoundCell. Dim FoundCell As Range Set FoundCell = .Find(what:=cbCust.Value, LookIn:=xlValues, lookat:=xlWhole, MatchCase:=faulse)How can i access the cell locations in it so i can change them, or reference them later in my code? example if "FoundCell" is...

Hello community! This is my first question~ I am trying to highlight an entire row if the data corresponding to that row in the column I created for "Percent of Profit/Cost" is over 50%. So basically what I have done is gone into Conditional Formatting---> Formula is =F$13>=.5 and then...

hey there, first post so bear with me! im given a problem and explicitly asked for the secant method, and understand the basics, but have only seen it used in examples that are squared or cubic... im given, numerically, an initial concentration (Xo) and the concentration of fluid being added...

Hi all, I have 12 tables which I need to merge into one big one if that makes sense? Eg Employee Name Start Date Progress Report Out 2 Week 4 Week 6 Week 8 Week All tables are set out like this but are broken down into departments. I now need to create one big table with: Employee...