Excel help formula which capture this as Prod
Closed
jai
-
Mar 5, 2011 at 04:07 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 5, 2011 at 09:10 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 5, 2011 at 09:10 AM
Related:
- Excel help formula which capture this as Prod
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Formula bar in excel missing - Guide
- Excel marksheet formula - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 5, 2011 at 09:10 AM
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)
