Forum Discussion
Everchanging spreadsheet
I am in the process of making a spreadsheet for parts on hold. I have cells below the list that I need to stay below any list above without inserting new cells. This first tab with forever change as parts will come and go on the sheet. I also a have separate tabs that show different buyers and I want the information auto transferred to the correct tab by buyer number but keep the main tab whole.
1 Reply
Your description still leaves a lot to the imagination, making it next to impossible to respond with any specific suggestions.
You'd help us help you by making available a copy of the workbook as it currently exists. If you're not able to link it to your posting here on this forum, then put it on OneDrive or GoogleDrive or the like and paste a link here.
Also be aware that taking optimum advantage of Excel might lead some of us here to recommend minor (or, potentially, major) design changes to the basic design as you've envisioned it.
