Hi,
Attached the workflow and Test Data.
I'm using one of the solutions provided earlier this week on my old posts. but need help with
Say in my new data set attached i have a another column 'No of Days to Reporting Month' which holds the value of -10
When i transpose the Data using your method it includes this 'No of Days to Reporting Month' and the Flag is set to 1 where i don't want this to happen.
what I'm looking for is i want to use your existing solution provided and on top of it i don't' want the Flag to be set to 1 for the 'No of Days to Reporting Month' column also i don't want any filters by hard coding to exclude this column since I'm using your solution on a batch macro where your solution runs on multiple sheets so is there a dynamic way of doing this without hard coding.
