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
Related:
- Populate rows on sheet1 based on values in sheet2
- Based on the values in cells b77 ✓ - 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
- 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
- Excel macro to create new sheet based on value in cells - Guide
- How to insert rows in excel automatically based on cell value without vba ✓ - Excel 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.
