Populate rows on sheet1 based on values in sheet2
Closed
nickki
Posts
2
Registration date
Wednesday July 10, 2013
Status
Member
Last seen
July 10, 2013
-
Jul 10, 2013 at 03:51 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 10, 2013 at 07:51 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 10, 2013 at 07:51 AM
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
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
Related:
- Populate rows on sheet1 based on values in sheet2
- Instagram account based in wrong country - Instagram Forum
- How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history ✓ - Facebook Forum
- Based on the values in cells b77 b88 - Excel Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
3 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 10, 2013 at 06:43 AM
Jul 10, 2013 at 06:43 AM
how are the values in sheet1 and sheet 2 are inputted. are there any formlas in sheet1 . check
nickki
Posts
2
Registration date
Wednesday July 10, 2013
Status
Member
Last seen
July 10, 2013
Jul 10, 2013 at 07:05 AM
Jul 10, 2013 at 07:05 AM
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...
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...
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 10, 2013 at 07:51 AM
Jul 10, 2013 at 07:51 AM
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.
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.
