Hello,
I am curently serving overseas and I have a excel scripting question. I have 3 years of weekly updated workbooks that I would like to display in chronological order. These workbooks contain 5 worksheets each with specific data ranges that track equipment issued to different organisations. The data ranges aren’t in the same location on each sheet i.e one worksheet has 5 differnt organisations on it the next 3 etc. Is there a way to pull the data ranges out for each specific organisation and display in chronological order the data so I can see the change in the amount of equipment on hand ( when they gain and/or lose equipment)? I have a basic understanding of scripting and I have tried to modify several that I have found online, but I am either implementing it wrong or I’m searching for the wrong script. Any and all help is greatly appreciated.
