Expert: Aidan Heritage - 5/22/2008

Question
Dear Sir,



I have posted my posts so many sites but could not find any specific result. My friends told me about this site.

Therefore, I hope I find my answer from this site.

My FIRST question is:

I have a Zone Wise sheet i.e.
Nz01, nz02, nz03.wz01, wz02, wz03, sz01, sz02, sz03 and so on.

Now I want to copy this data according to Zone Wise in another sheet and another workbook for example nz01
In sheet1, nz02 in sheet2, and wz01, wz02, wz03 in another workbook, sz01, sz02, sz03 in another workbook and so no.



Is any function or VBA OR MACRO can help me

My SECOND question is:



This is my sheet
POINTS   REDEEM POINTS   TOTAL
4500   2000   4500
4500   2000   4500
8500   1200   8500
10500   5000   10500
10500   5000   10500
9500   4000   9500
9500   4000   9500
     


     
POINTS   REDEEM POINTS   TOTAL
4500   2000   4500
     
8500   1200   8500
10500   5000   10500
     
9500   4000   9500
     



 






NOTE: The Cells (HARDEEP. WILLS.DAVE ALL ARE MERGED AND CENTRE)



Because this sheet has 1800 or more data, some data has same and I want to merge and centre the same data.

Moreover, after every 15 days, I received this type of sheet and it is very difficult for me to merge and centre one by one

Any help will be appreciate

Thanks in Advance

Hardeep kanwar  

Answer
I will certainly do my best to try to help you, but I don't follow the questions I'm afraid - it doesn't help that this site is text only - if it helps to email me with sample files you can get me at aidan.heritage@virgin.net - I'm fairly hopeful I will be able to get you something that does the work.