Update cell based on date criteria VBA
Hi Everyone -
I'm working on making a sales report more easily "update-able". The spreadsheet is lengthy so I would like to incorporate VBA code that only pastes a certain formula for a specific date.
I attached a rudimentary data set to the post. Essentially I would like the formula in cell H2 to be pasted into column B of the "Dataset" tab only for the rows where the dates in column A of the "Dataset" tab match the date in cell B2 of the "Date" tab.
Any help would be much appreciated!
With this macro, you don't need to use the formula. In the workbook you posted, the date in B1 of the "Date" sheet is not found in column A of the "SALES DATA" sheet so no value will be returned to the "Dataset" sheet.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thanks for the help , this works in this instance but is possible to do .formula = ... code because I have a formula that I use as a forecast.
Try:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks