Populate rows on sheet1 based on values in sheet2

Closed
Posts
2
Registration date
Wednesday July 10, 2013
Status
Member
Last seen
July 10, 2013
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hi,

I need to populate rows in sheet1 -- S.No, Name , Address, Contact No. with the values present in sheet2 -- S.No, Name , Address, Contact No.

Problem is as soon as I change the S.no in Sheet2 the old values/rows from sheet1 get nullified --

I want the old values/rows to remain when I am entering new S.No in Sheet2. Any thing possible?

Sheet2 has provision to enter values of 1 row at a time.

Thanks in Advance

3 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
how are the values in sheet1 and sheet 2 are inputted. are there any formlas in sheet1 . check
Posts
2
Registration date
Wednesday July 10, 2013
Status
Member
Last seen
July 10, 2013

For Example
Sheet1 has data like
S.No. Name Contact#
1 ABC 123
2 DEF 456
3 GHI 789
4 JKL 101

As soon as I enter a row in Sheet2 (provision to add only 1 data set)
it should automatically get appended to sheet1.

Sheet2
S.No. Name Contact#
5 mno 112

Next when I add row 6 in Sheet2, row 5 should not get deleted from Sheet 1.
Hope u understood my problem...
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
some ambiguities in your explanation
do you enter in sheet2 only one serial number data or more
once this data is copied in sheet 1 do you erase existing entries in sheet2 and add new serial numbers data or just add the new serial umber data. in the latter case how to find out which number have already been added to sheet 1 and which are not.

anyhow I am giving a clue

while copying from sheet 2 to shee1
if you use the code statement (in a macro)

cells(rows.count,"A").end(xlup).offset(1,0).pastespecial

when this code is operated the new data or even a number of rows from sheet 2 will be pasted in a new row in sheet1 without deleting the data you have already added.