I am trying to automate my company budget in Excel. The scenario is, On Sheet 1 I have all the account codes which refer to different account type, e.g.
500101 500102 500103 500105 700101 700102 710000
All 5 series refer to expenses and 7 series to recoveries. On Sheet 2, I have a specific calculation related to these account codes.
What I am looking for is: Pick a specific range of account codes from Sheet 1 to sheet 2 automatically, and if there is any change in the future, it should updated automatically.
For example, I want to extract all
5001?? account codes to Sheet 2.
500101 500102 500103 500105
500104 added afterwards, it should be updated on Sheet 2.