Hi all, I have a cashflow spreadsheet with Income and Expenses shown over a 25 year period. It is a simple sheet with income category and growth assumptions and a simple formula like =F2*(1*G2), copied across several columns. If I wish to add one off expenses or incomes in future years, I would then have to add an amount in the relevant column and potentially add a comment. What I would prefer to do is to have a separate sheet with a list of potential one off expenses, dates and values e.g. Trip to Peru, 2017, £5000. Of that information the value of £5000 would be added to the year 2017 under holidays in the first sheet. If then we wanted to put another holiday in that period it would add that value to in that year. Is there a way we can do this elegantly??
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Adding data into a cell in one worksheet from a list on another
- Thread starter Outtahere
- Start date
NARAYANK991
Excel Ninja
Hi ,
There is no problem as long as the descriptions , dates and values are in separate columns ; even within the same column it may be possible , but it is certain that if implemented using formulae , the formulae will be complex ones , and even the VBA code would be more involved.
Having everything in separate columns makes it quite easy. If you can upload your workbook once again after you have entered at least half a dozen such entries , preferably with a variety of dates , the required formulae can be suggested.
Narayan
There is no problem as long as the descriptions , dates and values are in separate columns ; even within the same column it may be possible , but it is certain that if implemented using formulae , the formulae will be complex ones , and even the VBA code would be more involved.
Having everything in separate columns makes it quite easy. If you can upload your workbook once again after you have entered at least half a dozen such entries , preferably with a variety of dates , the required formulae can be suggested.
Narayan
Thank you for your reply. I have attached the spreadsheet again with another sheet (sheet 1) with example descriptions, value, category and year. Hopefully this will give you a better idea about what I hope to achieve.Hi ,
There is no problem as long as the descriptions , dates and values are in separate columns ; even within the same column it may be possible , but it is certain that if implemented using formulae , the formulae will be complex ones , and even the VBA code would be more involved.
Having everything in separate columns makes it quite easy. If you can upload your workbook once again after you have entered at least half a dozen such entries , preferably with a variety of dates , the required formulae can be suggested.
Narayan
Attachments
NARAYANK991
Excel Ninja
Hi ,
Can you indicate where these expenses should be added ?
Narayan
Can you indicate where these expenses should be added ?
Narayan
Yes, in the first sheet titled Forecast Inc Exp in the rows with the same category (expenses) and the columns against the years. e.g in Holidays row in the first sheet £2500 would be added in 2017. In the Home Other row £5000 would be added in 2025. Does that help?Hi ,
Can you indicate where these expenses should be added ?
Narayan
NARAYANK991
Excel Ninja
Ok I have changed that now so that the expense now goes into the Hobbies Category. It is quite a formula you have put in there (thanks) and so it would help for me to study it and copy and past that across the entire sheet.Hi ,
See your file now ; except for the expenses labelled Boat , the others have been done. I do not know where Boat is supposed to go. Can you do it based on what has been done for the others ?
Narayan
Attachments
NARAYANK991
Excel Ninja
Ok will try this evening thanksHi ,
See if this is OK.
Narayan