Populating a cell from formula in another

Kannand · #1 02-26-2017, 08:00 PM

Quote:

Originally Posted by Kannand

I'm trying to update the column B with today's date based on the date value in column A and a couple of other values in other columns. If column B is already populated, I need to leave it untouched. I'm trying to get this in a macro so one could click a button to have this updated. The will be new records added to this spreadsheet every week and this update would be necessary.

I just came across this code in another post, that seems to work....

Sub update all()
Active sheet.Range("j4:j1048517).Value =Active sheet.Range(l4:l1048517").Value
End Sub

jeffreybrown · #2 02-26-2017, 08:11 PM

Quote:

Originally Posted by Kannand

I just came across this code in another post, that seems to work....

Still not sure exactly what you are doing as you talked about formulas and now you're talking macros. Not sure how what you posted seems to work when it doesn't even compile.

Code:

Sub update_all()
    Dim LR As Long
    With ActiveSheet
        LR = .Range("I" & Rows.Count).End(xlUp).Row
        .Range("J4:J" & LR).Value = .Range("I4:I" & LR).Value
    End With
End Sub

The code above will first look at column I to see what the last rows is then copied column I to column J.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Entering a column value in a cell, to be used as part of a reference in a formula in another cell	paulkaye	Excel	4	02-26-2017 04:18 AM
Populating ranking depending upon ranges of previous cell's data	sryder	Excel	5	04-07-2016 03:37 PM
Populating a table cell wit document properties	milena	Word VBA	2	04-15-2015 07:28 AM
Formula in cell b1 using cell a1 if a1 is over certain number	pumkinbug87	Excel	5	12-03-2013 12:34 PM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM