Hi, I have a workbook containing over a hundred sheets. In each sheet, some columns are protected. I need to make an almost identical workbook but with only...

I have a pivot table with data linked to an access database. I went to pivot table options and checked the box under the format options area "Grand Totals for...

Trying to do a pivot table to calculate processing time using Beginning Inventory + Received - Ending Inventory. Used formulas to 'Reverse' Ending inventory...

hai All can any one tell me how to by pass a registration program to use futher macros in excell work book

Hi Just Judy, Bit hard to read your layout when columns don't line up row1 reserved for column label headings: c2: 500 A3: 2005-04-01 (a date) B3: 10...

A sheet can have a variable range of adjacent cells each containing the value =1 The range defines the perimeter of, or surrounds a group of empty cells...

I'm looking for something to use with my restaurant , purchases,sales,combined.I want to see how my sales are doing with what I purchase.

I have a list of hyperlinks that are stored in fields(Range A1 through A200, for example). I would like to print them(essentially send it to Acrobat Distiller...

When entry of data is completed, how to put a stop that the record is completed and copy the data to a database created in another worksheet

I would like to create a query. .. ie. NFL sched for 2005. on the 1st sheet that pulls individual team info from the 2nd sheet. So I will input a team, and...

Ever since I installed Adobe Acrobat 6 Professional, the new workbook task pane fails to close when I open a file. Is their a fix for this? I have searched...

Excel 2003: had 2002 version. Data plotted correctly. Next time I opened file, data displayed as a series rather than a scatter chart, though the data range...

Tudo sobre hospedagem de sites , planos profissionais , economicos e muitos outros , sua empresa na internet por apenas 2,99 ao mês! http://hostbrasil.rg3.net

Tudo sobre hospedagem de sites , planos profissionais , economicos e muitos outros , sua empresa na internet por apenas 2,99 ao mês! http://hostbrasil.rg3.net

When I hit the spacebar in an excel spreedsheet, The last character entered is deleted how do I change this to stop deleting characters?

Hi see my response under microsoft.public.excel.misc you also might like to check out pivot tables see www.contextures.com/tiptech.html for...

I want to make a chart/graph that will have 3 columns where I can enter my bills and have them automatically calculated. !st column the name of company, Second...

This is one option: ColB: =LEFT(A5,SEARCH(",",A5)-1) ColC: =RIGHT(A5,LEN(A5)-SEARCH(",",A5)) This is the...

At conclusion of filtering a subset, we want to dump the records to MSWorks. Not all records (rows) are copied over. Can someone advise the accepted way of...