ooking for a starting point (completely new to VBA)
First Step: State your business Rules

  • Stk weeks left is below X and country X profit is below X then increase selling price
  • Stk weeks left is above X and country profit is above X then lower selling price
  • If country X achieves X sales and country X profit is below X then increase selling price
  • If country X is below X sales and Country X profit is above X and stk weeks left is above X then lower selling price


Second Step: Describe your Data
Examples
Sheet1
  • Stk Weeks Left in , Column A
  • Stk Weeks Left lower limit in Column B
  • Stk Weeks Left upper limit in Column C
  • Country Profit in Column D
  • Etc

Sheet2
  • Country Sales in Column A
  • Country Sales Lower Linit in Column B
  • Country Sales Upper Limit in Column C
  • Etc


Third Step: Refine your Business Rules (yes you will see things you didn't before)

Fourth:
Create a road map of when and where to look at and compare data
Examples
  1. Go down the list of Stock Items on sheet3 in column A
  2. For each Item,


  • look at the Weeks of Stock left in Column B

  • Look at the Company Profit , Column C on Sheet4
  • Look at the Company Sales numbers on sheet 5 column F
    PLace Raise/Lower Price notifications in Sheet 1, Column X

Fifth:
Rearrange the data so the code can use it better.

Sixth: Ask the Experts at VBAExpress what to do next.