I have links in sheet C that link to sheet B but now I need them to link to sheet A instead. Is there an easy way to change all the references in sheet C? ...

Hi I need a macro that will create a new worksheet and insert an image into it based on all the images in a particular directory. The worksheet name should...

I would like to obtain anyone's template in excel for doing "make versus buy" decisions

Hi, I have a 1500-row mailing list that includes the guests' account numbers in one of the columns. Some guests have multiple addresses (work, home, etc) so...

I have been searching for a tool to take a dashboard i have created in Excel and put it on a website for sharing. I have built a complete dashboard in excel,...

Hi - Is there a way to subtotal a list...once I create a list the subtotal feature is not available. I also fail to see the difference between a list and...

i have a list of job codes in Sheet 1 column V that need to be updated with new codes listed in Sheet 2 column B. Sheet 2 column A contains the old job...

I have a worksheet with dates of mm/dd/yyyy I need to reformat them now to be yyyy/mm/dd Whats the formula for that?

A user cannot see any sheet tabs or the horizontal scroll bar even though show the sheet tabs and horizontal scroll bar are selected in the Advanced Options....

Hi I am trying to create a formula that will look in column "b2" which will be a reference to a month i.e Jan then if the answer is Jan, then look in column...

I've built a picture display in excel using the (widely recommended) link: http://mcgimpsey.com/excel/lookuppics.html It works superbly! But once I reach...

I have two work sheets that contain bill of material information of about 3000 component items required to build a system. There have been updates to the...

Hi When adding for example overtime I format the cells to be :mm and this will add beyond 24 hours. However for any value over 24 hours the formula bar...

I have a worksheet with several columns. One of the columns is entitled image which I've hyperlinked to image files. I thought that if I were to email...

There is a code that has been found that opens our password protected files even thought the sheet is protected is there a way to prevent this. AAAAABBAABBf...

I would like to move sheets from one Excel workbook into another. Currently, I have a template that requires me to copy and paste one sheet at from one...

Is there a way to email, just one worksheet froma workbook, don't want to send entire workbook, right now have to do alot of copy/paste into an email with...

If I have a set of veritcal data for each employee, but each set of data could range from 1 to 4 vertical values, is there a way to change the following...

I'm creating a checklist in Excel 2007 and would like to know how to add a date in an adjacent cell automatically whenever I enter a specific # into another...

I am working with an OFFSET formula that was provided to me to help move vertical data to horizontal data. In the original formula,...