Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get Excel to auto sum after it has been saved with data. | Excel Discussion (Misc queries) | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Want to auto hide rows in excel when no data in a certain column. | Excel Discussion (Misc queries) | |||
auto fill sequancial data | Excel Discussion (Misc queries) | |||
Is there a way to get an auto page break as data changes in Excel. | Excel Discussion (Misc queries) |