Hi friends,
i have excel file where it has report period in column a, subsequently data downwards,the macro has to copy between two report period andvry report period should paste it to the next sheet , so every report period should in separate sheets.
the sheet is attached.
can some body help me on this
regards
som
Ok this is fine. Do you want only data under the headers to be copied? What should the sheets be named?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
from one report period to other report period it all the data should be copied to the new sheet , with name as data 1 ,data 2
some body can help me on this
Yes, i understood the issue. But should this also be copied -
Report Run Date: 11/28/2011
Producer: Ajg-glendale
Office Code: 23
Use this code. Open the excel file, press Alt+F11, you will see a code window open. On the left hand side, right click on Microsoft excel objects and insert module. Copy the code below into the module. Save the file. Go to Tools->Macro -> Macros (or Alt+F8) and run the macro.
Please Login or Register to view this content.
hi thanks for the help , its awesome , fantastic now ords to explain , my 20% of the work on a daily basis is reduced , you have made the magic for me. one more help please now the data is into different sheets , now i want to combine the data , which has unique producer name data into one sheet.if i have only one data for the producer name that will be in a separate sheet.with the sheet name as producer name.
Hi arlu ,
can you please help me on the next also , very thankful to you in advance.
So do you want the data in the same format with reporting period, report run date, etc? Or just the table data one below the other?
ya in the same format with reporting epriod report run date etc,
Wouldnt it be better to segregate the data into producer-wise sheets at the first instance itself?
Use this code-
Please Login or Register to view this content.
fantastic man, realy amazing , the last one for me , please , the sheets now with the producer name , can it converted into pdfs with the producer name, in that sheets report period to report period should come in one page . and get save in d:\pdf\ . if this is done that all it is . and i don't know how to thank you for the help. if this is possible let me know.
Hey my pleasure. Thanks for the rep points too. Your file can be converted to pdf but i have never done it before. Sorry. What you could do is post a separate thread regarding this and someone will surely help you out.
thank you thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks