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
Any suggestions on how to get a table that updates each time a spreadsheet is opened.
Basically want a table that reflects new data that has been input into another sheet. The other sheet has a unique, key column which I feel could be useful.
Effectively each time I open it I want to clear out the existing data and replace with anything that has been newly input in the source worksheet. Data only gets added at the bottom of the source workbook.
I could do it with a macro but that would be quite convoluted (it's to integrate into a flow and they can't use macro enabled workbooks). Am I missing anything or should I just bite the bullet and take that approach?