Thread: auto x-fer of data

Trying to keep a specific list of data in ws A. what I would like for xl
to do is:
If I insert a row I would like it to insert rows in the other ws
corresponding to the changes in ws a.

Ex
If I insert a row between a5 and a6 in ws A I would like to insert a
row between a5 and a6 in ws B


--
Custermd

Custermd Wrote:
> Trying to keep a specific list of data in ws A. what I would like for xl
> to do is:
> If I insert a row I would like it to insert rows in the other ws
> corresponding to the changes in ws a.
>
> Ex
> If I insert a row between a5 and a6 in ws A I would like to insert a
> row between a5 and a6 in ws B

The simplest thing in my opinion would be to insert your row, with or
without data, select the entire Sheet1 by left clicking the square
between A and 1 (top right), Copy, select Sheet2 tab, select cell A1
and Paste. Sheet2 is exactly like Sheet1.
You can automate it with the following Macro:
Sub Macro1()
Cells.Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste
Sheets("Sheet1").Select
End Sub
Assign it to a Ctrl + key and it is a two punch function


--
jahoobob