Previous Topic Next Topic

Copy data from one sheet to a new workbook

Closed
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 - 14 Feb 2011 à 23:24
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 18 Feb 2011 à 11:24
Hello,

I have a data in excel and from which i made 4 pivot table on 4 sheets naming sheet1, sheet2, sheet3 & Sheet4.

now i have to copied these four sheets to a new workbook (Workbook name is equal to the value of cell B3 of sheet1 of workbook with data) having four sheets naming, Value, Unit, Product & Subproduct respectively.

I have predefined headers in these four sheets (in first 7 rows in all sheets). which are same in all sheets:

A2 = Name of workbook
A4 = MIS for the month
A6 = Prepared by : Rahul

I have to copy data of pivot table of sheet1 from cell A6 to end of pivot table and paste this to the new workbook's Sheet name Value in cell A8 to further.

same things is to do with other worksheets

Sheet2 to Unit.
Sheet3 to Product.
Sheet4 to Subproduct.

Please give me the macros to do this.

Thanks!

Rahul

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
18 Feb 2011 à 11:24
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note: your data need not be to be real data but a good representative of how data looks like