I'm trying to create a button with a macro vba. I have a button that show a form in a sheet, when the user fill the form and click submit the macro receives...

I have a worksheet with a column for Name and a column for Amount. The subtotal in the inserted subtotal line does not show the subtotal amount in bold,...

I do not access to Lotus Smartsuite and need to import an old Lotus wk4 spreadsheet into Excel with the formuale intact. It would be huge hassle to recreate...

Hello - I'm wondering if there is anyway to control cell color based on a condition? If a cell is not empty - color = red If the date is older than last week...

This should be very easy, BUT can't figure it out. Excel 2003. I have a single sheet with 7 columns and around 550 rows. I made an Index on the top area of...

Dear Sir/Madam, I have produced a Spreadsheet whereas when someone makes a payment it shows as the date of payment in cell B10 and the amount in cell C10...

I'm sure this is an easy one... I have 2 worksheets (S1 & S2). Column 2 in S2 contains a list of ID's that I want to search in column 8 of S1 for and return...

I have a problem for an excel formula. I want to convert 1 to 0, 2 to 0,...... ..., 10 to 0. And convert 11 to 10, 12 to 10,............, 20 to 10. I know...

Hello, Using Excel 2007. How do I get the opening sheet to always open up displaying what's on the HOME tab, such as the Bold option, etc. ? Thanks.

I need to calculate hours per thousand. Can someone give me the formula to...

I want to compare 2 lists on separate worksheets - (A2:A9) on both sheets. The lists contain text. If the lists are equal I want the text in cell A1 on the...

I have an address list I want to print on avery 5160 labels. does anyone know how to do this?

quick question - if I perform a simple calculation of =(a1+b1) in the m1 cell, and then need to use that result in another calculation in the n1...

I've read some of the existing questions/answers ..... and I'd like to ask..... I'm using Excel 2002/XP. I currently have one file (Task List) with...

¼ìÄê¤ý, ¦ÊÅܬP§g, r102030r, ¥§¶ø·s¤B 4 ±ø¥´¹v¥J.

Hello, I am relatively need to Microsoft Excel and I need help creating a simple Macro. I would like to create a Macro that will: - take the value of the...

I have a table which I need to sort, e.g.: 2000 2039B 2026 2167 2239 2242 When I run Sort, I get

cen anybody help mi how to calculate in first row theres lets say time when started something in hour- minutes format in second row time when finished also in...

Hello, I have a vertical bar chart (ie. a 'column' chart) with staff names along the bottom (x) axis and their hours up the vertical (y) axis. The staff names...