![]() |
#1
|
|||
|
|||
![]()
Is it possible to have a formula in one cell while the result populates another? For example, I have a formula in cell A5 which I'd like to use to populate cell B5. Is this possible?
Thanks in advance. |
#2
|
|||
|
|||
![]()
Can you give more specifics?
What's the formula in A5 and what exactly are you expecting in B5? |
#3
|
|||
|
|||
![]()
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.
|
#4
|
|||
|
|||
![]() Quote:
Sub update all() Active sheet.Range("j4:j1048517).Value =Active sheet.Range(l4:l1048517").Value End Sub |
#5
|
|||
|
|||
![]() Quote:
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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
paulkaye | Excel | 4 | 02-26-2017 04:18 AM |
![]() |
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 |
![]() |
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 |