Can the offset be used in the below formula for the information in column "K"? In column L have the the following formula's L46...

I am trying to create a formula to help me with the below scenerio. I need to calculate how many days of PTO time someone would get based on years of...

Hi, i need a macro that will copy datas from sheet1 : J5 ;D13 ;D14 ;D15 ;F15 ;E19 ;E20 to Sheet 2 to range A:G. But i need the macro to paste to first empty...

Excel2003 ... I have formulas which calculate some cells to ... "" ... Blank Issue ... When I sort these cells the "" (Blanks) come to the top ... I wish to...

I've set up a connection to an Access DB to pull data over for my worksheet. Once the connection is made, and the data is over, I can no longer open the file...

Hi Please help me how to calculate the number of hours and minutes Between two columns: Ex: Beginning Apt. Ending Apt. 2/1/10 9:40am and ...

Hello, I have a large worksheet with data (columns "A", "B", "C", "D" "E", "F" & "G"). (I'm using only a few records for reference). Here are the...

On main page of spreadsheet I have space for names and addresses of third party agencies we use. A separate tab (called Third Parties( contains the full...

Hi there, I have a spreadsheet in which Column A looks like this; 0034-MILTON KEYNES 0034-MILTON KEYNES 0035-MARBLE ARCH 0035-MARBLE ARCH 0039-EAST...

Why won't the following macro work to create a page break - in particular it is giving me an error at the InStr line Sub b8Pagebrk() Dim theRange As...

Hello All, My code below is rather lenghty to just print several graphs, but I still have a problem. This is used by many people within the plant. The code...

Is there an accessible flag that indicates whether Conditional Formatting of a cell is active? I'd like to show a value in one cell based on whether a...

Every time I click open within Excel 2007 it always defaults to a folder called Sage Line50 instead of my default file location within documents. This has...

Does anyone have any suggestions on how to import web link into Excel and avoid frame on web page? When I browse following link, it look fine on IE, but when...

Is there a way by clicking on a check box, it would do the following to a particular cell: 1. insert a border 2. insert a data validation list 3. colour the...

I am trying to use the Function Wizard in Excel 2003 for multiple IFs and ANDs. When using the AND function what is the best way to get back to the IF...

Hi, I have Excel 2003 installed. Whenever I copy text or table from IE7 and paste into Excel (default HTML format), Excel will freeze up (cursor shows busy...

I have 4 colums on for start date one for start time one for end date and one for end time I need to find a formula that will give me just the difference in...

I have in column A a list of say 100 codes of which many may be duplicated. I wish to produce in column B an automatic list (produced without further manual...