Making Mailing Labels – How can I make mailing labels from an Excel name/address list? I have tried using the Mail Merge Wizard in Microsoft Word and I get...

hi all, I need some advice : below is my problem sheet, I want to sumif I 1 to dv 1 = 1( period ) and g1 to g100 =2 ( which room ) to get a period total for...

Hi, Can anyone help me with this request? I can copy the data in cell D4 of worksheet 'Sheet1' to,say, cell E5 in Sheet2 in the same workbook by typing into...

Hi, Can anyone advise me on this? I have a 3 x 3 matrix with columns A,B,C and rows 1,2,3. Each cell contains a simple link such as (=J6) but all 9 links...

Chester1 wrote: Please can anyone tell me how to remove links inspreadsheets If you refer to hyperlinks: Just right click a link or a cell containing a...

Consider the the below example: Sheet1: (This is what I have) A B C D E F 1 x x x y y y 2 x x x y y y 3 x ...

In previous versions of Excel, I could easily manipulate links by using the copy/paste and find/replace functionality. For example, I have the link ='Charts...

How do I see previous post from last week?

This is my first post, so bear with me. Can some one confirm if this is the same issue as Discussion “One workbook copies links from another?� started on...

Hi, why when I use vlookup on cells that have a formula in does vlookup return me 0.00 values...

I have a massive file which contains many sheets and i have one summary sheet with a column of hyperlinks which reference each sheet separately. Since i...

We are using a workbook for our payroll. The file has aheet with every employee's name plus a summary page. The file is 5.67MB. The summary page is linked...

is there a way to write a statement in Excel (like an IF Statement), that would display a specific picture if a certain #/word/etc is typed in a cell? ...

Dear All, I have a worksheet with lots of formulas. Some of these formulas are linked to other workbooks in the same directory. Is there a way I can identify...

I am unable to extend a date series, even using the Series menu itme under Edit. It is not recognizing that the four dates I selected are a series. What is...

How can I find the cells that have an external link to another workbook. Thank you. Branko

Hello How to make a version of a table by changing source data in another workbook and retain original version of the table easily? I lose the original...

Please, someone have a macro for sorting hyperlinks? When I sort a selected area with hyperlinks the resulting hyperlinks are disabled or mixed-up. I can send...

I have created a worksheet in Excel 03. I am trying to link a large number of the cells to another worksheet in the same workbook. When I use Paste Link to...

I'm using Microsoft Query to bring in some data. I have the query in SQL so i can do some groupings and count values in one of the fields. My problem is I'm...