Auto updating table from another worksheet

[clemsoncooz]

I am not sure if this request requires VBA programming or not. Basically, I am trying to automate a copy and paste function.

I have a cell data range from A114 to I152/153 (merged cell) in a worksheet titled CONTRACT. My goal is to have whatever is showing on worksheet CONTRACT to also be applied to worksheet titled INVOICE #1. Meaning, if I were to delete entire rows or add entire rows to worksheet CONTRACT, that the resulting table within CONTACT is identical to what is shown on INVOICE #1. But I want to do this without have to RE-copy and paste once a change is made within CONTRACT.

Able to be done with VBA? If not, how can it be done with VBA?


My usage of VBA programming is very very minimal = noob.


Thanks in advance!

[dilipandey]

Hi,

This requires VBA.
A simple macro can be created which will copy data from CONTRACT and paste in INVOICE #1 every time you do something on CONTRACT sheet. This can also be triggered via a custom button. If you are fine with this, would request you to upload the sample workbook containing above mentioned worksheets. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[clemsoncooz]

Okay - I am uploading a sample workbook to explain my problem.

If you look at the attached and look at worksheet 'CONTRACT.' Say I want to delete entire ROW 15 (Red5/Red6). I would then want entire ROW 4 deleted from worksheet INVOICE#1.
If I wanted to insert a row above Row 22 on CONTRACT (below white5/white 6 and above white7/white8) then I would want an row inserted above row 11 on INVOICE#1.


These are only examples and not the exact actions that I want to occur. I am only using this as an illustration so that whatever occurs to the data on CONTRACT, I also want the same thing to happen in INVOICE#1 reagardless of the location of the data (meaing that the beginning and ending locations of the data ranges do not occur in the same locations on the worksheets).

sample.xlsx

Does this make sense?

Thanks for looking at this with me!

[dilipandey]

Hi,

Thanks for providing details.
Check the attached workbook where I have provided a macro which works as per current scenario, but off course you might need to change the references to suit this to your actual workbook / worksheets. Open the macro (alt + f11) and edit the codes below my green remarks.

Hope this helps

Regards,
DILIPandey

<click on below 'star' if this helps>

[clemsoncooz]

very cool.

Thank you.

[dilipandey]

You are welcome...

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>

[lukar]

Hi DILIPandey,

I have pretty similar problem.

I have in one workbook (document) database (table) of components and prices. I want that this table will be automaticly (without pressing any button for activating macro) created or updated (if any changes in database table would be done) in another workbook (document) every time I open this document.

Can you help me please?

Regards,
Luka

[dilipandey]

Hi Lukar,

welcome to the forum.

Please do not post your query in another user's thread rather start your own :-
http://www.excelforum.com/forum-rule...rum-rules.html



Regards,
DILIPandey
<click on below * if this helps>