help me please

Help Me PLease! I am working on an estimate sheet at work and cannot seem to create a formula that will allow all options to work. :confused: I need to create a formula that will reference the minimum of one column but it must only choose numbers greater than zero. I also have a check box...

I’m trying to automate a task that I perform daily at work using VBA. I’ve used very basic VBA code to manipulate data in excel before, but never anything involving access. Below, are the instructions that I’m hoping to convert to VBA code. I would be more than grateful for any...

I have created a timesheet for my employees to capture applied time and leave across multiple projects. I have ONE major problem. I don't know how to calculate the time for each of the time applied codes (i.e. sick leave, vacation leave, regular time, administrative leave, leave without pay)...

Hi Guys, This has no code, just a lot of data. Each week I receive 20 - 30 workbooks filled with numbers that have to be added to the tally next to names on a masterlist. There are 6000 names on the masterlist, and each workbook will be adding a few to the tally next to some (but not all) of...

Any help much appreciated. I have a spreadsheet and a worksheet change event which checks Column B and show's a message box when either "Personal" or "Corporate" is entered in the cell. It uses an OldValue variable to ensure the macro doesnt fire when the change is occurring to a currently blank...

I am in dire need and have spent hours trying to get this right... I need to pull the latest 25 data cells in a row for use in a graph. The data is set up like this starting in cell D76: "Jan-03" "Feb-03"...."Sep-10" *blank* *blank* *blank* "33.51" "36.60"...."74.71" I need to have it so...

Thank you for reading First of all I am realy not good at this so I would like to ask you for help. :rofl: I need to create a sheet I have this table: <TABLE style="WIDTH: 904pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1201><COLGROUP><COL style="WIDTH...

OK, one more attempt at posting... it keeps logging me out at super inconvenient times. So, I don't know anything about VBA. But I need this sheet done as soon as I can. I have a bunch of tags and I want to look at the errors for each of them. A friend of mine helped me make a macro to make...

Im trying (for 2 days now) to create a macro to create a set of dynamic named ranges. there are column headers in row 5 and 5 rows below that there is the beginning of my data. Heres where the sticky part comes in: i have another table below my data that references the above table (that is...

Hey, im not the greatest at excel, and i need to make a formula that tabulates stats. i would need each agent to be calculated month-to-date from stats on different excel sheets.. ok basically i have two different excel documents that calculate daily stats for two different campaigns.. they...

Hi, I have this weird problem of date formats of the same worksheet being changed and appearing wrongly when accessed by different people from different machines, original file being saved in the network common drive. I am unable to find the reason, as the same file being accessed by me works...

I have March Madness Tournament Bracket set up in Excel and I am working on Multiple Pages... A master sheet which I will input winners into and individual sheets for people's picks. I have it set up with Conditional Formatting to have correct picks Green and incorrect picks RED (w/ a strike...

Hi, I have a workorder that looks like this: <table style="border-collapse: collapse; width: 749pt;" width="978" border="0" cellpadding="0" cellspacing="0"><col style="width: 129pt;" width="172"> <col style="width: 20pt;" width="26" span="31"> <tbody><tr style="height: 13.5pt;" height="18">...