anandbohra
10-10-2007, 12:06 AM
:hi: All
I am having Data of 20 Companies for 450 daya (total rows = 9000)
now through VBA i created individual sheets for all 20 companies
now i want to split that 900 records to all the sheets respectively as per company name can any one provide me VBA code for that
data is arrange as follows
Co Name - Date - Open - high - low - close
abb - 1/1/07 - 10-11-9-10
acc - 1/1/07 - 15-17-15-16
.......
& so on
now i want all the data which contains ABB in column A goes to Sheet named as ABB with full records & so on
pl help me.
I am having Data of 20 Companies for 450 daya (total rows = 9000)
now through VBA i created individual sheets for all 20 companies
now i want to split that 900 records to all the sheets respectively as per company name can any one provide me VBA code for that
data is arrange as follows
Co Name - Date - Open - high - low - close
abb - 1/1/07 - 10-11-9-10
acc - 1/1/07 - 15-17-15-16
.......
& so on
now i want all the data which contains ABB in column A goes to Sheet named as ABB with full records & so on
pl help me.