Posts by Stephenbb1

Thank you very much Carim, Brilliant that solved my issue

Thank you very much Carim, Brilliant that solved my issue

Hi
I hope you can help me
I have a code which highlights the selected cell, this currently applies for the whole sheet, but I only want it to apply in Row 1
Eg: If I click on any cell in row 1 I want it to highlight & if I click on any other cell in the sheet, do nothing
This is the code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.ScreenUpdating = False
' Clear the color of all the cells
Cells.Interior.ColorIndex = 0
' Highlight the active cell
Target.Interior.ColorIndex = 8
Application.ScreenUpdating = True
End Sub

TIA

[TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

[TD="width: 424"]I don’t know if what Im asking for is possible in excel preferrably without using VBA[/TD]

In the Master Sheet

I want the stock level of each item on each invoice I create to

be added to the amount in column T as outgoing stock & to remain after Ive saved the invoice to a folder

And likewise for purchase orders items to be added to the amount in column S

as incoming stock

Im Thinking I may need some means of booking the stock in & out

[/TABLE]
[ATTACH]n1214154[/ATTACH]