Richard has attended:
Excel VBA Intro Intermediate course
Excel VBA linking information from new worksheet
I have a VBA code that open a new worksheet with different department names. These departments will then record and total Income and expenditure for the department. The existing code opens the department and I can record the income/expenditure.
Next....
I want to link each department's Income and Expenditure total to be recorded in existing worksheets "Schedule 3" and "Schedule 9" respectively; this will then list each department and its total under each other. These totals will be updated as the information in each department worksheets is changed.
How do I link each new sheet and information to the existing schedule.
RE: excel VBA linking information from new worksheet
Hi Richard
Would it be possible for you to send the VBA code you have so far so we can assess the best way to link the data. You can either paste it into the message or exporting to a text file and then clicking Upload after Submit.
Thanks. Sounds like it should be possible to have a procedure that creates links to your department data.
Regards
Doug Dunn
Best STL
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
