Main Area and Open Discussion > General Software Discussion
Need a little help with an Excel file please
Stephen McBride:
Hi,
I have zipped the Excel file (unable to save it to XL format, could be an Office 365 thing!)
In a nutshell, each time I manually deduct from cell B, I would like cell D to automatically increase by the same amount.
I hope this makes sense.
Thanks all and stay safe.
tsaint:
1. Over in column G, set up the column to contain Columns B + G. eg in g2: =b2+d2, then copy down
2. Copy column G to column E, but instead of the normal paste, use "paste special" and paste VALUES rather than formulae
3. Setup column F to contain column E - column B eg in f2: =E2-B2
4. Column F heading becomes "Sold" and Column D can be deleted
Target:
pretty sure I can automate this, but it might take me a few days to organise...
TSaints solution works, but seems (to me) like a convoluted way of doing it
Stephen McBride:
Thanks guys, really appreciate any help :)
tsaint:
Target.. would really like to see the automated version, hopefully elegant - expect I'd find it useful too or at least get some good ideas.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version