Hi everyone,
I have a very particular but simple format that I need to keep for a sheet and unfortunately I need to be able to let any user of it break free of any automation and just enter values (so I made a paste pivot table values macro but we have some real technophobes here). I've provided a pivot example and my desired text-format result so it is clear how everything should be laid out.
Attached is a very simple example of what I would like to be able to do:
1. Take data that has been put into InfoEntry sheet (6 lines)
2. Always paste the Profit/Loss per the accounts line (first) with the number to the right hand side of it.
3. If there are entries that are tagged "Add" (second) or "Less"(third) then paste them next in the format given. (Simple compact layout with an indent)
4. Paste the last line "Adjusted Profit"(fourth) and the amount given at the bottom but with double lines (as shown).
I'd be very grateful to anyone who can help me with this. Thank you all for your time.
Limebaish
Bookmarks