title: Macro in Excel to Format data fields on multiple sheets
body: <p>I am trying to write a Macro to parse through all the worksheets in a spreadsheet and set the data format on a report that looks like this: </p>
  
  <p><a href="https://i.stack.imgur.com/wvIMm.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wvIMm.jpg" alt="Report Example"></a></p>
  
  <ul>
  <li>TY / LY  FP   for Sales and Stock = Number no decimals </li>
  <li>FP VAR = % Value</li>
  <li>TY /LY FP  COVER / COVER BRN = Number 1 decimal place</li>
  </ul>
  
  <p>Please note that when there are no data rows returned (e.g - Sales for High Tops in the example below) - the category is omitted in the cross tab.
  <a href="https://i.stack.imgur.com/pjzNM.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pjzNM.jpg" alt="Report Example 2"></a></p>
  
  <p>Please note, I am new to Macros in Excel - I am a BI developer and have some coding experience but not in VBA.</p>