On Thursday, February 8, 2018 at 9:49:25 AM UTC-8, Robert King wrote:
>
> Hi Everyone
>
> I have a very wide sheet and sometimes it gets difficult to follow which
> row contains the data I need.
>
> I would love it if excel could overlay shading or a colour to highlight
> the row and column of
I have a table where data changes continously (stock market data). I want
to apply IF formula. please understand with given example.
A1 = 10
B1 = 20
C1 = 5
D1 = where i want to put formula.
Now the value of A1 keeps changing. I want that if A1>B1, it shld write
"Buy" in D1 cell. Similarly if
Sorry - Start from the DATA Entry sheet. It will go to range B2 then down
to the last entry, then it will copy the last entry and on sheet All Data
it will find the last entry and go one below it and paste.
Thanks, David
On Sunday, February 11, 2018 at 4:03:43 AM UTC-8, who wrote:
>
> This
This was fast and dirty, but I hope it helps. Thanks, David
Sub PostEntry()
If ActiveSheet.Name <> "DATA Entry" Then End
Range("B2").Select
Selection.End(xlDown).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.Copy
Sheets("All Data").Select
Range("B2").Select