Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula help ... moving to next cell everyday
I have a cell that is linked to another page to pull in the MTD cash
posted per client. I need a formula to put in a column that will show 0.00 and fill in everyday automatically. Example Today N8 = 100.00 M10 = 100.00 Tomorrow N8 = 150.00 M11 = 150.00 The next day N8 = 250.00 M12 = 250.00 etc |
#2
|
|||
|
|||
No one with an idea?
|
#3
|
|||
|
|||
Not using formulas.
You could use a macro and run it whenever you want... Option Explicit Sub testme() Dim wks As Worksheet Dim FromCell As Range Dim ToCell As Range Set wks = Worksheets("sheet1") With wks Set FromCell = .Range("N8") Set ToCell = .Cells(.Rows.Count, "M").End(xlUp).Offset(1, 0) ToCell.Value = FromCell.Value FromCell.ClearContents 'maybe??? End With End Sub chisigs2 wrote: No one with an idea? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
need help creating formula based on cell value | Excel Discussion (Misc queries) | |||
How do you copy a cell formula down a column without displaying n. | Excel Worksheet Functions | |||
using content of a cell in a formula in another cell | Excel Worksheet Functions | |||
Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions |