excel help

I have an excel spreadsheet where I need to count the number of occurances where the date is over 3 days from current date. Is this possible? Or, do I have to put a < "current date" , and have to continually change it when I remove/add data? Hope this makes sense! My first time posting on a...

Hi, I'm having a nightmare trying to find code to display (and edit if needed) the previous and next rows when using my userform. The userform is simple, includes 7 textbox and 1 combobox. I've managed to get the userform to populate the data sheet on the first blank row but can't figure out...

HI, Am trying to make a holiday entitlement document for my business and need some help on the formulas as am rubbish on excel. I have found a excel doc on this site but cant get it to work. Start Date 25/03/2010 Staff Name Hol Year Start Hol Year End Accrual Start Date...

Hi! I desperately need some help with some excel macros, can anybody help please? I need the VBA code so that an excel macros will run once automatically when, for example cell A4 = 1. I've managed to get this far with the VBA: Sub copytohere() If...

I have a list that was previously fully filled in, but I had to go through and insert many rows. Now with those inserted rows I want to insert the same text that is in the cell above. BQ5 - Anderson BQ6 - Anderson BQ7 - Anderson BQ8 - BQ9 - Anderson BQ10 - Anderson BQ11 - BQ12 - Rochester...

Currently I have a worksheet that employees record data obtained from testing. The data cosists of measurements of impurity levels in a specific substance. What I would like to happen is : The employee manually inputs a value into a cell. This value is then automatically added to a list that...

I have a spreadsheet of about 4000 rows. I have shipping box dimensions in 5 columns per box (L x W x H x Weight x Freight Class), with a total of 8 potential boxes. Columns AR - CE (40 columns) are split into the 8 groups. Box 1 :AR - AV Box 2: AW - BA Box 3: BB - BF ..... and so on. For some...

In row A I have about 5000 SKUs that are generally a few numbers and then a few letters. For some reason, even though I go to "format as number", they all still have errors saying "Number Stored as Text". Because of this formatting error, the V-lookup doesn't return a value. But as soon as I...

I posted a thread earlier about a balance sheet and now I have another question. I have an expenses table that dispalys all the expenses that happened during a given year, the year is displayed on the formula as a reference to a cell that contains a drop down list where you pick the year. So...

I downloaded and used my excel jeanie and test it and i am stock on the clipboard part, where i can see my selected cell in internet explorer how can i use that in this forum??? Please Help me!!! Thank you in advance

Hi Guys: Im trying to build a fairly basic calculator but I need to use 1 cell twice with 2 functions. Does that make any sense??? My problem lies in cell C8 Here are my formula's =SUM(D3/(A8*10)) This one is in C8 And this one uses C8 =SUM(C8*A8)*10 but is in D8 =SUM(D3/(A8*10)) gives me...

Hello, first, I’m happy to be a new member of MrExcel. It's an honor to be here.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> For some reason, it's extremely difficult for me to understand Excel jargon.<o:p></o:p> I know it will take time to...

Hello, first, i'm happy to be a new member of MrExcel. It's an honor to be here. For some reason, it's extremely difficult for me to understand Excel jargon. I know it will take time to learn it but for me, i learn much better from experience than reading up on it. With that said, can someone...

I am creating a First Article report generator and I have Sheet 1 as the place where all the numbers are entered for Sheet 2 to compile accordingly. I need help with what I need to do to be able to Generate rows on Sheet 2 from Data in Sheet 1. _____________________________ SHEET 1 A1 is...

Hi there I am trying to do a bar chart that shows data by day of week. I'd like to days of the week to be in a specific order..howver Excel is putting it in a random order or I can only sort by the values by day. Is there a way to fix it so If I want it to be sunday, monday etc...it stays...

Hey everyone, I am creating a database in Excel with about 1,000 commercial properties. With each property I have several different columns of information (sq ftage, lease space, property type, address, etc), I also have pictures of each property. I have each column so I can sort with what...

Hi, I need to make a table for every hour for 1 day. I need to a "treatment" cell and 24 "hours" cells in one row. Can someone, please help me make the cells smaller just in these rows without decreasing the cells above them. Thanks in advance. Mark

Hi friends, My Query: I have an excel sheet which contains an weekly calendar i have radio buttons fr weeks(say week1,week2...week5) combo box for choosing month and year now for example if i enter particular data in a cell with date july 1st...i.e; 1st week ,july month...year 2009...

Hi! I am creating a very interesting thesaurus (words and their synonyms) for a script that I am developing! Why I need excel, when it is in .php? Well, that's a good question! What I need for the .php script is this format: " A " => " B ", where A and B are the word (A) and its synonym...