When I do a Paste SpecialPaste Link, the cell looks something like ='MAIN'!$A$3. This is great, its just what I want. Now I remove the $ beofre the 3 and drag...

Hi all, I have a range of cells in a spreadsheet containing values, say cell A1 : C5. Example as follows: A B C 1 100 100 ...

Hi, i am quite new to excell and require some help, i am trying to solve a problem for a junior football team that i run. I have a list of 14 players and...

hi source cells a C4, C10, C16,..., C352 all of them have fixed 6 steps away from each other. Now I want to copy them in another sheet within same file but...

Hi Guys, I don't use excel for really complicated things and don't set up sheets frequently but when I do make a sheet I want a quick way to copy and past the...

I have a excel sheet that I import data from a external database and then i added columns to the sheet that have entries made by me. When the data refreshes if...

Having done my small business accounts for years in 'book' format I am now moving towards the idea of doing them on the computer. I am fairly new to the...

I receive price updates from me vendors as an email attachment. At times I need to retype the product codes because I am unable to sort or perform a Vlookup. I...

We are an advertising specialty business. We need to track each job/sale from the initial customer request for an item, through to delivery of the...

I need help with a problem that I'm having. I've got about 300 sheets in my excel workbook. I need to copy the data from cell B5 on every sheet,into a new...

I need help with a problem that I'm having. I've got about 300 sheets in my excel workbook. I need to copy the data from cell B5 on every sheet,into a new...

WindowsXP Excel 2003 A user received an Excel spreadsheet of name and e-mail addresses. When I clicked in the cell that contained the e-mail address it...

In a shared Excel workbook, when I select a tab to delete that worksheet, the Delete Worksheet command in the Edit menu is not available. -- May your computer...

This is my first post here so bare with me. I need help with a report I'm making. Each month we gather data on safety items. We track which items are safe and...

Hi I have a working Excel VBA macro and would like to use a form for all the inputs. I have the form and the code behind the text/combo boxes etc. I...

Hi there; I am copying specific cells from a file (actuallu use the address approach, like aa!c12) to another file. The cells address in source file are always...

I have two columns. One with dates and one with names: 09/22/77 Jane Doe I'm trying to sort these by months so I can keep track of people's birthdays. ...

how do I make the column labels repeat in a spreadsheet? When I follow the help directions, I am unable to "enter the row numbers" I keep getting a message...

I don't know what I'm doing wrong. All I'm trying to do is add a column of numbers. In cell L13, my formula is =SUM(L2:L12). All I get back is 0. I've checked...

Hi, I want to know how do I check if the text string starts with a specific character in if statement. I used ... =IF(ISNUMBER(FIND("v",'A2)),"OK","Not...