Hi,

I am writing a hobby application for which has the following:

Worksheet -- a cells B5:E5
B6:E6
B7:E7

Worksheet --b cells C5:F5 These cells contain the data
C6:F6
C7:F7

Now I want to do the following

a) link the data from Worksheet -- b to the cells in worksheet -- a
but I have the following problem,
When I click a "done" button for a certain row (say 5), C5 should be
deleted, and new data should be entered in the cells C5, C6, C7, to
F5, F6, F7 and now worksheet -- a should get automatically updated.

Is there any way to do it?


warm regards

karthik