Search:

Are there key strokes for the sum function? I searched everywhere and can't find them.

Thx in advance

I have a problem where I use mail merge to import data from Excel. The numbers from Excel are formatted to round to 2 decimals, but when mail merge brings that number into Word, the number has 8...

Each time I

Thank you Hans for replying. How do I create a new printer definition? Do I need to use Regedit and create a copy of the key? Or is there an easier way?

I have a printer that does color and duplex printing. I would like to set up copies of the printer in Settings/Printer & faxes with different options to do black & white printing and double sided...

You are awesom Hans and Don Thx much. I actually am reading about the VBA process, but you guys made it much easier.

Don;

Thank you for your reply. I am not much of a VBA programmer so I don

Each month I get spreadsheets that were downloaded from our corporate mainframe. These spreadsheets have text or numbers in 4 columns and have up to 1,500 rows. My dilemma is; in only one column, I...

This worked great. Thank you very, very much.

I

I want to create a macro that copies the value from a cell in a target worksheet into the cell in my destination worksheet. Trouble is that the target worksheet file name is always referenced in the...

In trying to get Excel to return the file name in a cell from a function, I can

I have two columns of data with different part numbers in each column. Some are matching part numbers others are not. Is there a way to easily compare each cell against the other to find duplicate...

Thx guys.
I got it now. But now I have another problem. I have about 50 worksheets where the name celllink and inputrange could be used. That

Thx Steve, but when I name the ranges and input that into the Format Control tab, I get the following error. What is wrong with my syntax?

T-Man

Now I

Thx, that worked great.

I am trying to use a cell reference value in an INDEX formula. The formula is

=INDEX(INDEX(T10:T107,$U$6,1)!$C$2:$O$15,INDEX(T10:T107,$U$6,1)!B2,1)

The first INDEX function is actually the...

Using the FORMS toolbar to create the combo box and then selecting Format Control, I have a Control tab where I can input the Input Range, Cell Link and Drop Down Lines.
Using the Control Toolbox I...

I am using the FORMS toolbar to add a Combo Box. I would like to increase the font size of the text that appears in the combo box. Can I do this using the FORMS toolbar?
If I use the Control Toolbox...

I am using a combo box from the FORMS toolbar. I input other values in other cells using the INDEX function. I'd like to lock the cells once the value is brought in, but if the cell is locked, the...

Thx for the tip, but both the Excel files are saved in the same folder and the Word document doesn

I am copying worksheets from one Excel workbook to another. When I do this, this the links I copied in the new workbook to a Word document don

All;
Is there a way to edit the text in links globally? I have copied several worksheets with links in that workbook to another Excel workbook. Those worksheets have links to Excel and Word...

<P ID="del"><FONT SIZE=-1>Post deleted by T-Man</FONT>