0
votes
0answers
24 views

Dynamic Excel page with many referances

I want to build a dynamic spreadsheet. I have a blank template for entering weekly information about different locations. Once this information is inputted it is saved as a new sheet and titled for ...
0
votes
0answers
88 views

Indirect lookup across spreadsheets

I have a spreadsheet that has information about all products for every week of the year. Currently I have a second spreadsheet that is setup to look at the first one for each field (currently has 52 ...
1
vote
0answers
66 views

How to create a formula which finds a cell that matches a range of other cells then produces a number if the cell appears.

am having trouble with finding a suitable formula for my spreadsheet in excel. In column A i have a list of postcodes (439 postcodes). In column B-BL i also have postcodes (these postcodes are in ...
1
vote
1answer
2k views

How do I add values in column B if column A contains the same employee surname more than once?

State of Data: I have column A which has names of employes and column B has number of hours. How do I add the hours if column A contains same employee surname more than once? I have been using what I ...
2
votes
1answer
2k views

Excel 2007 - changes on one sheet affecting other (without cell references)

Some strange behaviour I've encountered twice in Excel is that changes made to one sheet would be duplicated on another sheet in the same workbook. The first time, I typed values into a few cells on ...
1
vote
1answer
2k views

Is there a way to delete everything except what is selected in Excel?

I have an Excel template with 20 tabs (worksheets) and plenty of data in each sheet. When a user opens a copy of the template, he will only need to use one tab. Is there a sneaky way to select that ...
0
votes
2answers
572 views

Make comma separated list from column with blanks, fed by checkboxes

I want to make a spreadsheet where user can check boxes on one worksheet, and have those values then be brought over, comma separated, into one cell, on another worksheet. The values of the checkboxes ...
1
vote
1answer
676 views

Referencing a single row to multiple rows in Excel

I have a worksheet with a list of sales, one sale per row. In order to import this data into my accounting software, I need to create a separate worksheet that formats the data differently. Each row ...
1
vote
3answers
679 views

In MS Excel 2007, replace numeric value with same value plus function

For example, if Column A contains: 123 456 789 I want to replace values with: =(123/60) =(456/60) =(789/60) I know I could create another column to do something similar, but would rather know ...
0
votes
1answer
58 views

Auto updating similar formulas

I'm trying to see if there's a way to get my Excel sheet to auto update with new formulas as I enter it. For example if D4 down to D27 was the same formula(=SUM(B4/25)) and I wanted to change it too ...
4
votes
3answers
11k views

How do I delete excess cells in Excel 2007?

I am not the original creator of the spreadsheet so I am not sure how the person caused this. The issue is basically the excel spreadsheet has an excess amount of empty cells that won't delete and ...