Hi Folks, I am useing SQL Server 2005. I want to join two different tables data from two different Databases(Ex: 1. Database_X 2. Database_Y). Both...

Hello I have an excel sheet protected with a password and a VBA code when i open the sheet i can only see it in print preview i dont have the password is there...

How can I revise this formula to flag colum A with the following: If B3 is nontext (date) or "Blank" than "Blank" leave "blank" if not blank than enter a...

Hi everyone! I have a header and footer for this excel document. Is it possible for me to insert horizontal line just under the header and just above...

Is it possible for me to set-up a spreadsheet for others to use but will limit the options of the data that they can enter (text only), so that they may only...

I created an excel file for payroll purpose with each employee's pay info broke down in separate worksheets. Is there a way i can disable or hide other...

Ok so here's another one. I have 3 cells that I'm concerned with: ET (A2), Used (B2), Balance (C2) If it's the begining of the month ET is filled with a...

First I want to say thank you to Ashish Mathur for his post to my previous question. He answered it in full. I failed to share entire senario. My goal is to...

If I have for example the formula: Formula is =IF(F9-1=$E$6+3,1) which will turn my cell red, is there anyway I can turn it red and mark it with the number 1...

Please help with formula. I have a table that adds up (totals) a list of "time" in decimal form, and I want to also show this total number in hours and...

Is there any way to link 2 excel workbooks together in a separate workbook? Every week I export an excel spreadsheet from my business program and store it...

I have a large table created on a worksheet called 'Times' where I have sorted people into squads to compete in a competitition. They compete a few times...

There is an excel file in shared folder and every day its need to be updated by every user.But the problem occurs when everyone try to access it at same time...

We have a formula that randomly goes missing on one of our spreadsheets. =EOMONTH(B13,(-1)) It will be working and then you go in and you have N/A’s...

I hope you can help. I have a worksheet that when I have autofilter on and I filter on a selection I want the count of rows to be visible and stay visible. ...

Hi all, I was wondering whether there's any way for an add-in to define names (or something similar) that would be available from other workbooks. For...

Hi All, I've been breaking my head over the last 2 days but somehow can't get to the root of this. I'm working on a leave management solution for my office...

I have a monthly report that uses external data. If I import the data into excel in a code column and a data column format, how can I place this data in a...

When adding a column of numbers that are formatted as "accounting" and to two decimal places, I'm getting an incorrect total. It's only off by 1 cent, but I...