You are reading a single comment by @Sam_w and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Sam_w
Hey,
Hoping someone might be able to help me... I have been given some data in excel which sits across multiple tabs and workbooks, I need to collate all this data, which is all fine, I have written a macro that can collate the data.
The one issue I have is that the system this data comes from puts the identifier for the tab into an object embedded in each tab, and I can't work out a way of extracting this info from the object and pasting it into a cell, I have attached a simplified example, anyone got any ideas?!
1 Attachment