Hello Experts
Request you to help me build a macro to solve my current problem.
In excel sheet, I generally have cell entries of several thousands in Col 1.
I need to create macro where
a)It should automatically copy paste 1-1500 rows and paste them in Notepad and save notepad as Notepad 1.
b)Then it should copy paste values from 1501 to 3000 and paste them in Notepad and save notepad as Notepad 2.
c) Then it should copy paste values from 3001 to 4500 and paste them in Notepad and save notepad as Notepad 3.
d) and so on till the end of the Column1 values.
Data in column one in excel is something like below, and generally its of several thousands :-
http://subscriber.com/H/company360/o...23039000000000
http://subscriber.com/H/company360/o...nyId=463436001
http://subscriber.com/H/company360/o...nyId=468717210
http://subscriber.com/H/company360/o...nyId=468197934
http://subscriber.com/H/company360/o...nyId=463700194
http://subscriber.com/H/company360/o...nyId=564693430
http://subscriber.com/H/company360/o...nyId=564657070
http://subscriber.com/H/company360/o...nyId=469192392
http://subscriber.com/H/company360/o...nyId=633439476
http://subscriber.com/H/company360/o...nyId=477301910
http://subscriber.com/H/company360/o...nyId=465651615
http://subscriber.com/H/company360/o...nyId=462424017
http://subscriber.com/H/company360/o...nyId=465729320
http://subscriber.com/H/company360/o...nyId=464560759
http://subscriber.com/H/company360/o...nyId=460474344
http://subscriber.com/H/company360/o...nyId=562930578
http://subscriber.com/H/company360/o...nyId=464288241
http://subscriber.com/H/company360/o...nyId=464120716
http://subscriber.com/H/company360/o...nyId=464673227
http://subscriber.com/H/company360/o...nyId=464511133
http://subscriber.com/H/company360/o...nyId=512728098
http://subscriber.com/H/company360/o...nyId=565270766
http://subscriber.com/H/company360/o...nyId=462069021
http://subscriber.com/H/company360/o...nyId=560668006
http://subscriber.com/H/company360/o...nyId=564947158
http://subscriber.com/H/company360/o...nyId=468717210
http://subscriber.com/H/company360/o...nyId=564693430
http://subscriber.com/H/company360/o...nyId=633439476
http://subscriber.com/H/company360/o...nyId=465651615
http://subscriber.com/H/company360/o...nyId=462424017
http://subscriber.com/H/company360/o...nyId=464288241
http://subscriber.com/H/company360/o...nyId=464120716
http://subscriber.com/H/company360/o...nyId=462069021
http://subscriber.com/H/company360/o...nyId=564947158
http://subscriber.com/H/company360/o...nyId=564681971
http://subscriber.com/H/company360/o...nyId=464552285
http://subscriber.com/H/company360/o...nyId=468670851
http://subscriber.com/H/company360/o...nyId=768030285
http://subscriber.com/H/company360/o...nyId=560661639
http://subscriber.com/H/company360/o...nyId=474267957
http://subscriber.com/H/company360/o...nyId=474143273
http://subscriber.com/H/company360/o...nyId=465651714
http://subscriber.com/H/company360/o...nyId=470567660
http://subscriber.com/H/company360/o...nyId=769933685
http://subscriber.com/H/company360/o...nyId=565296456
http://subscriber.com/H/company360/o...nyId=476723952
http://subscriber.com/H/company360/o...nyId=464403221
http://subscriber.com/H/company360/o...nyId=475376948
http://subscriber.com/H/company360/o...nyId=479371254
http://subscriber.com/H/company360/o...nyId=512009051
http://subscriber.com/H/company360/o...nyId=460067813
http://subscriber.com/H/company360/o...nyId=564593895
http://subscriber.com/H/company360/o...nyId=473856664
http://subscriber.com/H/company360/o...nyId=470036609
http://subscriber.com/H/company360/o...nyId=472107606
http://subscriber.com/H/company360/o...nyId=512737826
http://subscriber.com/H/company360/o...nyId=464611644
http://subscriber.com/H/company360/o...nyId=464053644
http://subscriber.com/H/company360/o...nyId=477711865
http://subscriber.com/H/company360/o...nyId=478382005
http://subscriber.com/H/company360/o...nyId=464590798
http://subscriber.com/H/company360/o...nyId=562942888
http://subscriber.com/H/company360/o...nyId=460535612
http://subscriber.com/H/company360/o...nyId=460572055
http://subscriber.com/H/company360/o...nyId=465614407
http://subscriber.com/H/company360/o...nyId=511137051
http://subscriber.com/H/company360/o...nyId=564594463
http://subscriber.com/H/company360/o...nyId=460029368
http://subscriber.com/H/company360/o...nyId=474002016
http://subscriber.com/H/company360/o...nyId=474418121
http://subscriber.com/H/company360/o...nyId=461904968
http://subscriber.com/H/company360/o...nyId=461045622
http://subscriber.com/H/company360/o...nyId=565339553
Bookmarks