Copy paste usedrange data and delete duplicate rows

[Ravi321]

Hi friends,

I need your help, below are the things which i am trying for my code to perform.

• Copy data from range B5:F13 (range will not be fixed)
• Go to sheet “Archive” paste copied range as value from cell A3
• Delete duplicate rows from sheet “Archive” (Like in the sample file last two rows are duplicate so they should get deleted) may be concatenation formula be used for it
• After a month again some new data can be manually added in sheet “Master” below the existing data. So next time when the same VBA code is executed then the whole copied data from “Master” sheet should be copied and pasted in sheet “Archive” below the data which is present earlier. After that again the VBA code should search for the duplicate rows from the entire data and delete it

Link for sample data file
https://www.dropbox.com/s/xfp2aw5wxan6scf/Sample data.xlsm

 

[venkat1926]

See data and formula in G5andH5 formulas copied down. sort according to col H and delete rows manually

Master

*	B	C	D	E	F	G	H
4	Name	Country	Age	Sex	Salary	*	*
5	abc	India	23	Male	46000	abcIndia23Male46000	*
6	def	Sri Lanka	24	Male	48000	defSri Lanka24Male48000	*
7	ghf	UK	26	Female	52000	gh***26Female52000	*
8	klm	UK	20	Male	40000	klmUK20Male40000	*
9	opq	USA	28	Female	56000	opqUSA28Female56000	*
10	xyz	Africa	31	Female	62000	xyzAfrica31Female62000	*
11	shf	Singapore	24	Male	48000	shfSingapore24Male48000	*
12	ghf	UK	26	Female	52000	gh***26Female52000	delete
13	klm	UK	20	Male	40000	klmUK20Male40000	delete

<tbody>
</tbody>

Spreadsheet Formulas

Cell Formula G5 =CONCATENATE(B5,C5,D5,E5,F5) H6 =IF((COUNTIF($G$5:G6,G6))>1,"delete","") <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4