Excel VBA linking information from new worksheet | Excel forum

Resolved · Urgent Priority · Version 2010

Tue 11 Sep 2012, 10:25 Delegate Richard said...

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.

Tue 11 Sep 2012, 15:33 Trainer Doug said...

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

Thu 13 Dec 2012, 11:10 Trainer Cindy said...

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.

Thu 20 Dec 2012: Automatically marked as resolved.

Training courses