You are reading a single comment by @Chalfie 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.
@Chalfie
That's what I do!
(this is good, it confirms i'm doing something sort of right)
The whole routine in vba opens the two, cleans, etc, closes both (after saving the data and splitting it by local area). I then have a look at the cleaned data and transfer it to the dashboard sheet.
If i spot errors there, i try and work out how and correct for them for the next time in the vba.