Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

The 2010 version of Microsoft's spreadsheet application.

1
vote
1answer
30 views

How do I conditionally format all rows in a table, to display a different colour based on a cells value

I have developed a table (as seen below) which is designed to show a persons duties based on priority. If a person clicks the toggle on/off button, this will toggle colours on the rows of the table, ...
0
votes
2answers
29 views

Split data into new column

As per attachment i have column A having name with underscore "_' and bracket " [ " . I need a formula to get answer of column B means I need formula to get id before underscore and inside bracket . ...
-1
votes
0answers
11 views

Extract distinct row values from a sheet to another sheet based on max dates per unique rows

I want to extract rows based on max date or max B per unique values of col A and col c. Doesn't matter if it is vba or excel formula. Help please. Old Sheet New Sheet [2
0
votes
0answers
28 views

Possible to edit and mirror the same column in two sheets?

At present I'm using Excel and require a column to allow data input from two different sheets, but accept the latest input as the correct value. The workbook has two sheets within it, Sheet 1 and ...
-2
votes
0answers
8 views

I need to compare two sheets in excel and if email found need to add whole row into third sheet [on hold]

I have three sheets, from sheet one I need to take the email and need to find that email in sheet two and if found highlight that row and move the whole row into third sheet. And then change that ...
0
votes
1answer
20 views

Copy data from one sheet's cell to multiple cells in another sheet

I have this database where I store sales. I can find particular sales by filtering. I would like to have a button that then regenerates the sales as "receipts" in another sheet. This is my code for ...
0
votes
0answers
28 views

Match two columns on two different worksheets [on hold]

I need to see if my sample ID numbers in one spreadsheet are also in the another worksheet. I would like to match them and then identify the ones without a match. It is for billing. I get a list I'm ...
0
votes
2answers
50 views

Excel freezes when running macro

Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range Dim i As Integer Set KeyCells = Range("H4:H100") If Not Application.Intersect(KeyCells, Range(Target.Address)...
0
votes
2answers
51 views

How to solve “current printer is unavailable” message on opening workbook?

I have an Excel workbook that, on opening, displays a message "Current printer is unavailable. Select another printer." Followed by a dialogue box with a list of print drivers. Based on this thread, ...
0
votes
0answers
15 views

Calculate multiple worksheets using index match sum

I have a formula that works =INDEX('[Test.xlsx]Report 1'!F:F,MATCH(B8,'[Test.xlsx]Report 1'!A:A,0)) This will being me back the value 37; in report 1. -report 1 is a worksheet, and there is 6 in ...
0
votes
1answer
17 views

Index match finding the first value only

I have a list of employees with duplicates and each employee has a number which represents the number of sales. I'm trying to use the following formula to extract the highest sale for a given name, ...
0
votes
0answers
49 views

Graph and organize multiple categories with multiple data series each

I'm trying to organize and graph data on some cooling devices in a way that's expandable and easy to modify, i.e. graph only certain coolers, manipulate data/add new calculated data as needed. Here ...
1
vote
2answers
32 views

Select next row in Excel?

I've searched everywhere but can't seem to find a proper answer to this. Maybe I'm not using the right terms or something? Or maybe there is no answer... So as an example, if you select the cell A1 ...
-1
votes
3answers
70 views

How to divide duplicate rows in excel?

Say I have: ============== | a | | a | | a | | a | | b | | b | | b | | b | | b | | b | | ...
0
votes
0answers
10 views

VBA Excel Modeless Userform - unable to interact with another workbook

I have tried a search but I am unsure as to what to search for. I have a modeless Userform but when I try to manually interact another workbook it doesn't react until I click on the form then the ...

15 30 50 per page