Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
chisigs2
 
Posts: n/a
Default 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   Report Post  
chisigs2
 
Posts: n/a
Default

No one with an idea?

  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
need help creating formula based on cell value Brad Excel Discussion (Misc queries) 3 April 1st 05 07:51 PM
How do you copy a cell formula down a column without displaying n. Coddie Excel Worksheet Functions 4 January 18th 05 03:31 PM
using content of a cell in a formula in another cell mpierre Excel Worksheet Functions 3 December 28th 04 04:43 PM
Formula Result Correct but value in the cell is wrong jac Excel Worksheet Functions 2 December 17th 04 09:05 PM


All times are GMT +1. The time now is 11:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"