I have a spreadsheet for upcoming projects that will each have a figure budgeted in upcoming specific financial year or years. Financial years are represented by columns K-U with headings 2017/18; 2018/19 etc. Headings are all contained in row 1.
I have my main data sheet called 'All projects' and then separate sheets for each financial year (named 2017/18; 2018/19 etc.).
I would like to be able to auto populate my financial year sheets based on the 'All projects' sheet having data under the financial year column (K-U) i.e. if column K (2017/18) contains data, copy the entire row to sheet '2017/18' and so forth.
Additionally, in my main data sheet, 'All projects', I need to make changes to the rows, including moving the dollars around e.g. a project may be budgeted for $10,000 in 2017/18 (Column K) but to balance budget, I may need to push it to 2018/19 (Column L) etc. If this occurs for any project, I would need it to remove that row from 2017/18 sheet and copy to 2018/19 sheet etc.