Following attempt to create a formula in VBA is throwing a syntax error, but sure someone out there can do this.
PLANNER sheet has weekly sales values for products, with each week eight columns apart.
CUMULATIVES sheet needs the following Formula in Col E that will take each weekly value, and add the previous week's total to it.
So for row 3:
=IF('PLANNER'!K4="",'PLANNER'!L4,'PLANNER'!K4)+E2
(E2 being the previous week, so E2 will become E3, E4, etc with each iteration).
Problem 1: Code converts Col 'x' to "Col K", but can't work out how to also set Col 'y' as "Col L"?
Problem 2: Have added four double quotes for "blank" but it's not working.
Problem 3: Not sure how to add the "+E2" in the code?
To be clear, I do not want the Code to post the actual value from the Planner, I want it to post in each cell the Formulae that finds it.Please Login or Register to view this content.
All solutions, suggestions and recommendations welcome as ever.
Ochimus
Bookmarks