Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Interconnection between tables

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Interconnection between tables

Resolved · High Priority · Version 2007

Reply Wed 17 Nov 2010, 17:41Rita (guest) said...

Interconnection between tables

Dear Anthony,

long time since my last post...here I am with a new tricky question:

I have a big database (more than 700 rows x 30 columns) as source of data - let's call it Table1
I have created a new table that pulls out just some specific data from it based on some criteria - let's call it Table2 (much smaller - 50x15)

Now what I would like to achieve is to write some code that allows me every time I change data in Table2 automatically change also in Table 1. Only a numerical value or a string will be entered.
Could you please help, maybe providing me with some simple suggestions?

I hope to have givem you enough information.

Many thanks and regards,
Rita
(attended your course last July)

For upcoming training course dates see: Pricing & availability

Reply Tue 30 Nov 2010, 12:01Trainer Jacob said...

RE: Interconnection between tables

Hi Rita

Thanks for your post. To really be sure of any solution we will need to have a look at your working files which does take this beyond the scope of the forum.

If you would like to discuss this further please contact us.

Regards

Jacob

Excel articles

· Excel: Save Time With AutoFill
· Unsupported features in Excel 2007
· How To Create A Custom List In Excel
· An Introduction To Financial Functions In Excel 2010
· How Excel Can Help You See Into Your Business's Future

Please browse our web site to find out more about
excel consultancy and other Microsoft training courses.

Excel tip:

Ctrl+d's double life

Suppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae.

Ctrl+d has another use though. When I use the drawing toolbar to draw objects such as Text Boxes, Rectangles and Ovals onto a worksheet, Ctrl+d makes an instant duplicate of selected shapes. For example, I need five Text Boxes the same size. I draw one Text box and adjust it to the size I want, select it, then press Ctrl+d four times to get four identical copies.

View all Excel hints and tips