I have about 24 different workbooks which had a different worksheet, maintained by different users. Some time to analysis the data, I have to open up all the...

I always seem to waste time manually changing filled in series so I'm hoping someone here has an answer: I have a formula in...

I have 2 columns with dates in them, I want to change colour of the 2nd date dependant on the 1st. I can do that no worries but when I try to fill it...

Hi, I have spreadsheet comprising of 20 pages worth of data for over a hundred stores. I've created a summary page with a drop box enabling each store to...

I have a file that includes orders which are pulled from BPCS using Microsoft Query. This file shows a breakdown of orders by month by week to include past...

I am using the following code: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Not Application.Intersect(Target,...

Hi, As an example to a larger project I'm working, I have two columns of data I want to search for an entry, "dogs" for example. And I'd like a function...

Goal: I would like a cell to display a "Next" date by comparing text values in one cell to "today". Scenario: I have two cells. The first is a cell with...

I'm working on a spreadsheet to list work orders for customers needing PC and laptop repair. Some of the jobs will be under warranty and others not. Can a...

I have a spred sheet tracking absenteeism using the following formula =sumproduct(--('sheet1'!B1:B100="John Doe"),--('sheet1'!C1:C100="sick")) each time John...

I am trying to manage a few things I am selling and shipping off. In column a I have the price I sold it for. In column b I have the shipping price that was...

I would like to create a macro to save the current worksheet as referenced from a cell on the worksheet, save in a preset directory, and then print the...

I often have a need to compare a date with two other dates and see whether dateA is between dateB and dateC. I have tried to use the "IF" function but it...

I have a task where I have to compare the balance of each individual customer account in our company accounts receiablve in the current week to the previous...

I made changes in th wrong workbook and saved them. Is it possible to undo those changes even thought I have clicked on save?

Hi I have two tabs in my worksheet, is there a way i can view both of them at the same time? Thanks

Is there a way to save a worksheet as an image, ie. not as a spreadsheet with formulas etc. but just as it looks when printed? If I could save it as a PDF...

I have Excel 2007 but save a certain spreadsheet in Excel 2003. I use Compatibility Mode to edit document. I saved my document and all my formatting was...

Is there a way to format every other row as shaded (without manually doing it)? And, for visible rows only?

Excel2003 ... I need to determine fractional MONTHS between 2 Dates to 1 decimal place (17.3 months). DATEDIF is returning whole number of months which I...