2 Questions: 1. Is it possible to link one Excel sheet to another so that when data is changed on one it changes on the other. We do that all the time in...

Hi, I have a spreadsheet of meter readings for household utility usage (gas, electricity and water). The readings have been taken at irregular dates, which...

I have created a spredsheet and would like to generate a new number in a field every time the spreadsheet is opened. ie an order number, but do not know...

Hi there I really hope you can help. A macro wont work so hopefully you can! I want to automate copying values only of Worksheet "si" in the current open...

I have been working in an excel spreadsheet fine. I went in the other day to type in some items, and I was unable to type in the spread sheet. How do I...

how to remove existing format, like time to regular number see...

Excel2003 ... Col "H" contains Dates (mm/dd/yy), Text comments & Empty Cells. I wish to count dates by Qtr (excl Text) ... How many dates occurred...

I have a file that is pulling information from several large files via vlookups and hlookups. I've already broken all of the links of the larger files and...

How do I count how many rows contain nonblank in col A and blank in col B? It has to be a combination of both. If you find a nonblank in col A then check col...

The tab key jumps several columns to the right when I press it. How can I reset the tab key to move just one column to the right?

I'm trying to take the first name in a column and get a result of the first letter only in a new column.

Hello Guys, I am trying to record a Macro for exell and i am dealing with some information that changes size from day to day for example. 1 day i can have...

I would like to count unique values returned by an array after comparing it with a list. I have an array set up to return the averages of several students...

Hello, I have a chart with sources coming from a pivot table. The filter fields are workcenter and machine. There can be multiple machines in a workcenter....

I have never used Excel, but it came with Office 2003. My nephew is taking video of his pets and relatives. He is having trouble emailing the videos to...

I have a long list of names in column A, with blank cells every so often. In column B, there are list of numbers. Cake 8 Cookies 4 ...

How do I create a summarize report of data that is date driven? For example, I have a table of employee job history in which employees held the same job for...

I have multiple sheets in my workbook. Each sheet contains a company name, address, and I've assigned a Zone to it. Either a 1, 2, 3, or 4. Can I - easily -...

I imported a spreadsheet from excel to word and selected the options that would update the spreadsheet in word, The problem is in word the spreadsheet willl...

Column D7:D12 is calculated using the formula =SUMPRODUCT(--($A$6:$A$9637=A7),($C$6:$C$9637)) to get the total amount of components(A6) demand to build 1 per...