I have created subtotals and page break after every change in department. What I want now is to insert a row after the page break and add data -- yepidu

Hi, I posted this yesterday and did not get much response. I wonder if it cannot be done. Any way please read and help me with a formula. Thank you. Ok. I...

I need a formula which calc the required Head count Task Volume Set Targets Hours worked Head Count ABC 196500 85 3500 ...

Supervisors of this forum should take some measures in order to make e-mail notifications work again! -- Regards! Stefi

Hi There, I am currenly trying to keep a tab of my staff's extra mins/hours worked which they can use at any stage. I currently have two columns a running...

Hi, I have a requirement to display the maximum scored students based on the marks. i can able to display only one student if more than one scored the same...

How do I use a reffer to a current row in formula Example: A1*B1/C1 A&Row()*B&Row()/C&Row The example above doesent work but want column to be fixed and...

I hope the Excel pivoit table able to distinct count summarize Data ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the...

When I'm linking a cell in worksheet 1 to a cell in worksheet 2, all of the previously hidden rows in worksheet 1 automatically unhide. Can I do something...

I have designed a table and adjusted all properties, including page setup options and printing properties, in the proper manner. The table is OK in Print...

W2003 Storage server in a Microsoft cluster with storage on a Compellent SAN. Problems with Excel files. Lot of corrupted Excel files. Excel files with...

Hi, I have a requirement to display the maximum scored students based on the marks. i can able to display only one student if more than one scored the same...

I cannot enter a number containing more than 15 digits in Excel. Specialy whwn the no is like 1668001700025402. after entry it displays like...

I'm sharing Excel and word 2007 files on a SBS2008 server. Alle computers are windows XP with Office 2007 installed. When the users open an excel document...

Hello all, I posted this question last week but now I can't find it so forgive me if you have seen it. I work for a police department and am trying to figure...

When I open a spreadsheet with images in cells using Excel 2007, the images look fine. When I perform a print preview, the images are not aligned and at...

Hi All, Have a large database (approx 30 columns, hundreds of lines) and would like to run a quick report that pulls important related information from the...

I need to send someone an excel spreadsheet but they are using Mac Office 2004 and say they can't open the above versions sent from a a PC? Help much...

I'm trying to create a spreadsheet that calculates inventory with a column for initial inventory), total inventory used, Inventory remaining, and a column...

G'day All Would anyone know the macro to count the number of pages each that would print out for each tab. For example you had 3 tabs. First one is the...