I am using Macros in my excel sheets. I have protected my macro coding by locking it, so that no one can able to see my macro coding. But I want to protect...

I have problem trying to hyperlink a cell in Excel to a specific page in a PDF document. I have no problem using IE to hyperlink to a specific page...

I want Excel to autofill an alphabetic sequence. This is for equipment mgmt. purposes. From AAA to ZZZ.

I am using macros in my excel sheets. Can anyone tell me how i can assign the current date using macros.

Dear all, I found some examples of using Array operation like IF(ISNA(MATCH(... SUMPRODUCT(--(--A1:A100=5)) more advanced of VLOOKUP & Match. to get...

I am trying so filter a selected persons data, to get a correct cost for this person but at the bottom of the page it is also bringing up different...

I am using a lookup formula in Excel 2003 to display a product description when I enter a product code. I am having a problem with choosing what category to...

In a cell with row height set at auto-fit, I get an ######### error message after exceeding a row height of 100 pixels. The problem is not solved even if I...

Hi I have written a macro below to go through a list, copy each item in the list, open a template and paste the item on the template, close & save with the...

There is a cell in a row. The cell is merged with Columns C, D, E. When I apply Autofit to the whole row, some of the content in the merged cell is...

I know how to use the paste special transpose to move values, but need help on this. let's say I have these values in column A, starting at...

How do I make a formula that uses the fist cell as a starting position and then counts 4 cells down as the next result? Ex. A1 start cell, then A5, A9, A13,...

I'm trying to print a holiday chart onto one page, this chart was done manually rather than using the 'chart' option. I have fiddled around with the wide and...

I have a column of data going down that I'd like to transpose to go across the page so that I can add this info to data going across the page. I mean for...

Hello, I need help with setting up a macro that reads in different file names. Each file contains 4 columns of data that I would like to be imported in...

how do i work out the forumula for dividing

I am using HTML Help to display help information within my Excel program. After I close HTML Help, the file system thinks that the .chm file is still being...

I am making a list of all my DVD's, Cd's and etc. I want to be able to type in the following information in a non Alphabetized order and have Excel...

I have a large table of names, dates and financial calculations that I need to 'regularly' put into a form. The information changes each time. Right now the...