I have a first row of text wtih fields such as Account, Start Date, etc. These are my customized fields. In each column, I then have information. Is it...

I have created a link (reference only) from one tab to a second tab cell. Is it possible to do something to that link, or create a different type of link,...

I created a product price list with different headings within columns in workbook1 sheet1. (The reason for this was because I wanted to be able to easily...

When I export a Quickbooks "Time by Job Summary" report to Excel, the time is converted in a time and date format. If I want to put a dollar amount to that...

Your question doesn't clearly convey the layout of your BTA sheet, but let's assume that Column B is for Jan, C is for Feb, etc., and that row 1 contains...

I'm hoping someone can help with this. I'm trying to sum all the numbers on the left of a '/' and the the numbers on the right of the...

I have a spreadsheet that has duplicate values for a series of items throughout an engineering bill of material. I need to calculate total demand. Col ...

Dears, I am trying to do by formula the following but I failed: I have two columns, one has the distance and the other has the height level, and to draw it...

I have a customer list on one worksheet and a vehicle list on another worksheet. On both worksheets I have a customer number that is common between both - I...

I am trying to get the word "Successful" in a cell (B32) if another cell(B31) results/number fall between two percentages of less than 95% and more than...

Can I pull store #'s to another spreadsheet along with quantity of items? I have a Distribution spreadsheet with a list of 100 store #'s. I fill out the...

In short, I would like my date column (A) to be blank when I open the spreadsheet. Upon entering text information, always a persons name, into column (B) I...

I have a table that looks like this: January February Currency 1 Text 1 1.1000 2.1000 Text 2 1.2000 2.2000 Text 3 1.3000 2.3000 Currency 2 Text...

Hi all, I have a "true blood" XL 2007 .xlsb workbook that was created in XL 2007. There are no workbooks open in compatibility mode anywhere. The workbook...

HI i often open a file and leave open as a read only file , and whenever i edit a cell , i click on the "read only " toggle button then key in the password...

Hi, I have a data table where column A = Make (named MAKE), B = Model (named MODEL), Row 1 = Model Year (named MODELYR). On a different sheet, I have a list...

In Excel 2003, if I right clicked on a sheet, the option to hide or unhide is missing from here. I know that the option is in Format, but the option was also...

Hi I have used the following to get the average value from a set of data whilst ignoring zero values within the data...

I am trying to us a vlookup formula which is a little more dynamic than just a vlookup...I am looking to return sales figures for a given product accross...