Excel help formula which capture this as Prod
Closed
jai
-
Mar 5, 2011 at 04:07 AM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Excel help formula which capture this as Prod
- Excel @ in formula ✓ - Forum - Excel
- How to copy data from one sheet to another in excel using formula - Guide
- How to insert picture in excel using formula - Guide
- Excel position formula ✓ - Forum - Office Software
- How to change date format in excel using formula - Guide
1 reply
rizvisa1
Mar 5, 2011 at 09:10 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Mar 5, 2011 at 09:10 AM
Most probably you would need a macro to do that
General idea would be on sheet 1, use the event
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
this you can use to see if a new date has been entered on a sheet, then write that date to the sheet 2
also you can update the product information on sheet2 as things are changed in sheet 1.
I am not sure if it is doable via formula and even if it can be, it would be a memory hog and make your workbook as slow as my pay raise (ok may be a little faster than my pay raise but still it would be slow)
General idea would be on sheet 1, use the event
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
this you can use to see if a new date has been entered on a sheet, then write that date to the sheet 2
also you can update the product information on sheet2 as things are changed in sheet 1.
I am not sure if it is doable via formula and even if it can be, it would be a memory hog and make your workbook as slow as my pay raise (ok may be a little faster than my pay raise but still it would be slow)