Hi all,
My team is currently using an Excel file when frankly Access would be much more appropriate (but not possible). It's therefore a shared workbook - and I know this is also an issue.
Book1.xls
I've adopted a system in the attached workbook to get around from sheet 1 to sheet 2. It's not really fit for purpose. In the shared workbook, it keeps remembering the change history no matter how I try to get it to forget and the size of the file grows every time the copy macro is used.
With thousands of rows long, I don't really want to use =HYPERLINK(#Sheet1!$A2,Sheet1!$A2) in sheet 2. I'd need hundreds of formulas doing nothing while we add projects. It would be more efficient with a macro, just not the one I've adopted.
Please tell me there is a better way?
Bookmarks