how do i copy the exact data???

ZakiZelani

Estimable
May 20, 2014
1
0
4,510
0
this button help to copy all the data from table 1 to another sheet which i name it to table 2. however when i delete the some rows from the table 1 and then click the button to copy it to table 2, it does copy the updated version but the some data still in the table 2. (I'm not sure you guys get what i mean,hahahahaha)


what i mean is, for example, my data is from a1:a60 and i delete 5 rows. then click the button to copy to the table 2, the last 5 rows from the previous data is not deleted. you guys get it? table 2 suppose to have 55 data at then end but it stays 60 due to previous 5 data from the last time i copied still stays......


here is my code:

Sheets("all items list").Range("table1").Copy Destination:=Sheets("inventory").Range("table2")


 

JackNaylorPE

Distinguished
Can we assume that you are asking questions about a spreadsheet ?

Toms Hardware is probably not the best place to ask software question but when I want to copy data from Sheet 1 to Sheet 2 , I just duplicate (copy) the sheet ... For select data, highlight / copy / paste woks
 
Thread starter Similar threads Forum Replies Date
A Apps General Discussion 3
S Apps General Discussion 4
G Apps General Discussion 0
C Apps General Discussion 4
A Apps General Discussion 1
thepinkanator95 Apps General Discussion 6
E Apps General Discussion 4
B Apps General Discussion 5
ShadowsVoid Apps General Discussion 1
rvg90 Apps General Discussion 2
R Apps General Discussion 9
B Apps General Discussion 1
B Apps General Discussion 5
I Apps General Discussion 8

ASK THE COMMUNITY