Hi

Im having a major problem with my excel on mac. This problem came out of nowhere - somehow whenever I change the information in one particular cell it changes the same cell across multiple sheets. There is no formula in there - it is changing the text, font and font color, etc. Do you know how to unlink this cell without just deleting the whole thing? Let me know thank you!!

Eric

Im having a major problem with my excel on mac. This problem came out of nowhere - somehow whenever I change the information in one particular cell it changes the same cell across multiple sheets. There is no formula in there - it is changing the text, font and font color, etc. Do you know how to unlink this cell without just deleting the whole thing? Let me know thank you!!

Eric

- How to sum cells from different sheets according cell name
- VBA : how to count cells containing a specific character
- How to randomise cell values according to weighted probabilities
- How to extract cell number from Range data type
- How to read cell value from the filtered data?
- How to link cells so that if one is not answered then the other cannot be filled in
- How to compare cell content to a row pf data in excel and return .
- How to find cells containing exact text, and separate them
- How to change cell colour by simply clicking on it
- how to make cells read only??
- How to change cell colour by simply clicking on it
- How to link cells so that if one is not answered then the other cannot be filled in
- How to sum cells with a certain letters sequence
- HELP: How to Reverse Cell Content
- How to select cells (located in a column) for formulas in a row automatically?
- How to sum cells but not show zero if cells are blank?
- How to show cell value in form?
- Please teach me how to retrieve cell b1 or c1 data instead of a1 from sheet x for sheet y
- How to leave cell blank from formula until data is posted
- How to name cells with Do While Loop.
- How to make cell not editable
- How to format cell characters to ****
- How to sort cells by dates when some cells are links to other cell dates ???
- How to highlight cells

I would like to ask how to sum cells from different sheets according cell name. e.g. I want to sum all cells with name "subtotal" from sheet1 to sheet10 (number of sheets is not stable). On sheet1 subtotal is e.g. B3 cell, on sheet2 subtotal is e.g. D5, and so on... so I can't used direct reference like

=SUM(Sheet1:Sheet10!$B$3)

instead I'm tried something like:

=SUM(Sheet1:Sheet10!subtotal)

, which doesn't work.

is this possible without VBA?

Thanks a lot.

how to randomise cell text with weighted probabilities

Apple 0.19

Banana 0.36

Cranberry 0.30

Durian 0.15

Apple

Cranberry

Banana

.

.

.

.

.

Apple

Banana

Durian

I have this bit of code

For Each rcell In Range("C6:E9")

If rcell.Value "" Then

arr = Split(rcell.Value, ".")

If UBound(arr) 3 Then

MsgBox "Invalid format for IP " + rcell, vbOKOnly

End

End If

End If

Next rcell

in the Msgbox i am getting the value in the rcell , but not the cell number like C7 or E8 etc.

How to extract cell number in the above case.

I am able to find the total no of filtered records using below macro.

Sub CountVisRows()

Dim rng As Range

Set rng = ActiveSheet.AutoFilter.Range

MsgBox rng.Columns(1). _

SpecialCells(xlCellTypeVisible).Count - 1 _

& " of " & rng _

.Rows.Count - 1 & " Records"

End Sub

But I want to copy the cell by cell value and paste it in another sheet. How to read cell value from the filtered data? I don't want to copy the entire row or sheet.

Appreciate your help

Thanks

Shriswaroop

be filled in

--

dips112

------------------------------------------------------------------------

dips112's Profile: http://www.excelforum.com/member.php...o&userid=27825

View this thread: http://www.excelforum.com/showthread...hreadid=473321

Could someone help me on this?

how to compare cell content to a row pf data in excel and return ...

how to compare cell content to a row pf data in excel and return ...

If anyone knows how to find cells containing exact text, e.g. email address,

and separate/copy them to a separate list or column of cells.

Sheet has about 600 rows so doing it one by one with search function is not

appealing - there should be an automated way/formula to separate these cells.

All help appreciated !

Excel. I put together an activity where Kindergarten students graph

M&M candies according to colour. What I would like to do is allow for

cells to change colour when a child clicks on it with the mouse. (e.g.

for each yellow M&M, the child is to click on cell in graph under the

pic of the yellow M&M. These cells would in turn change to

corresponding colour.)

I would also need to know how to have cell return to original colour

when clicked on twice- in case a mistake is made.

I have an example of what I want to do- see he

http://www.scs.sk.ca/cyber/elem/lear...s/rec_sht.html

Thank you in advance for your help- I am really new at this and

unfortunately can't figure this out on my own.

Jovette

Anyone know how to do this?? I tried making the cells "protected" but it did not seem to do anything.

HELP!

-chris

Excel. I put together an activity where Kindergarten students graph

M&M candies according to colour. What I would like to do is allow for

cells to change colour when a child clicks on it with the mouse. (e.g.

for each yellow M&M, the child is to click on cell in graph under the

pic of the yellow M&M. These cells would in turn change to

corresponding colour.)

I would also need to know how to have cell return to original colour

when clicked on twice- in case a mistake is made.

I have an example of what I want to do- see here:

http://www.scs.sk.ca/cyber/elem/lear...s/rec_sht.html

Thank you in advance for your help- I am really new at this and

unfortunately can't figure this out on my own.

Jovette

column with following texts: abcd, bcde, cdef. How to sum cells which contain

"bc" sequence?

Reverse cell A1 ("smith, bob") to ("bob smith") and apply results in B1?

Additionally, any hints on counting text letters in cells ("xxxxxx" would equal 6)

How to use cells (located in a column) in formulas in a row automatically? I

cannot copy the formula to other cells in the row because the coping moves

the selection to another column, not to a another row in the same column.

Hi all,

can anyone tell me how to sum cells without showing zero if cells are blank?

regards

Simon

can anyone tell me how to sum cells without showing zero if cells are blank?

regards

Simon

How to show cell value in form ?

For example I want to show cell "A1" value in form with TextBox

Private Sub TextBox1_Change() ????TextBox1 show cell A1????? End SubThank you

I would greatly appreciate it if someone out there in cyberspace could send a reply that teaches me how to retrieve cell b1 or c1 data instead of a1 from sheet x for sheet y as soon as is convenient to do so.

The summarized situation: An Excel 2007 workbook that tracks a teams's project status...

The workbook contains two worksheets:

2.) Worksheet "X" consists of cells A2, B2, C2.

The title for A2 (located in A1) is "Planned step date",

The title for B2 (located in B1) is "Revised step date",

The title for C2 (located in C1) is "Completed step date".

These three cells all contain formatted dates (mm/dd/yyyy).

2.) Worksheet "Y" consists of a single cell... A1.

The purpose of cell A1 of worksheet Y is to simply display the current status of a specific project step's date....

So here we go....This is what I can't figure out and am asking help solving...I have tried many different conditional statements, formulas and looked all over online, to no avail...

I need the date listed in worksheet Y, to only display worksheet X's A2 if B2 and C2 are blank....BUT...

If worksheet X's A2 has a date and B2 ALSO has a date (even if the B2 date is earlier than A2's date) then I need worksheet Y's cell A1 to only display worksheet X's cell B2 date. Also...

If worksheet X's A2 has a date, B2 has a date, AND C2 has a date (again, for all cell's older/newer dates do not matter) then I need worksheet Y's cell A1 to only display worksheet Y's cell C2 date.

I would greatly appreciate any help solving this...

Thank you,

- Todd

VB:What I would like to do is rename the cells with a Do While Loop. I seen the previous thread similar to this, but I am not sure how to increment the Range("B1).Select statement in the loop.Range("B1").Select ActiveWorkbook.Names.Add Name:="PG1", RefersToR1C1:="=Menards!R1C2" Range("C1").Select ActiveWorkbook.Names.Add Name:="PG2", RefersToR1C1:="=Menards!R1C3" Range("D1").Select ActiveWorkbook.Names.Add Name:="PG3", RefersToR1C1:="=Menards!R1C4"If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

I have the following statement together so far.

VB:This code works but is very lengthy and occupies a lot of space. If I can figure this out then I will be able to apply same solution to eliminate another 300 lines of code.Dim CellRef As Integer PgNumber = 1 CellRef = 2 Do While PgNumber < 65 Range("B1").Select ActiveWorkbook.Names.Add Name:="[PG]& PgNumber", RefersToR1C1:="=Menards!R1C&CellRef" PgNumber = PgNumber + 1 CellRef = CellRef + 1 LoopIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Thanks in advance for any help.

values from the combobox.I have done this using by locking the cells

but it's not good, can anybody tell how to do this in anotherway Thanks

The cell is containing password used during log-in process.

Any idea how to sort referenced date cells without getting that error ?

Thank you for your help.

akm