Hi Experts,
Firstly, thanks to Lisa, the Group Moderator, for adding my Workbook entitled AutoTransfer to the Group's Files Needing Help list. It helps me enormously to explain what I'm trying to do.
On the first sheet (INPUT) there are 4 columns, A-D, and headed ID, Month, Amount, and Paid respectively. There is also a BeforeDoubleClick sheet macro which lets me, after double clicking on a cell in column D copy the amount in the same row from column C.
On the next sheet (TOTALS) there is a 2D matrix made up of a named range called months, which extends from B1:M1, and another named range called names which extends down from A2:A43
When double clicking on Column D of sheet INPUT, in addition to copying the amount from column C to D I would also like to add it to the existing amount in the correct cell on sheet TOTALS using the name and month of sheet INPUT Columns A and B as search parameters.
So, for instance if I double clicked INPUT D9 then 80 would be copied over from C9 but I would also like the 80 to be added to TOTALS I 9, which is for Grace: August.
I can get round it using formulas but I think VBA would offer a more elegant solution but my knowledge doesn't extent that far and I can't find anything of the web that would help thus I'm throwing myself on your mercy.
Regards
Graham
Posted by: grahamfellows2002@yahoo.co.uk
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar