I have a file with downloaded only one sheet from system and want to automatic insert the multiple sheets with some relevant informations.
Please refer my attach file.
In this file,I have downloaded 'MB52' sheet.Now,I want the following datas with the help of VBA codes:-
1-Automatic Insert a sheet ,name-'PhyInv from MB52 sheet'.In this,text in row no.4 should be BOLD.Further,automatic calculation on columns 'AB' to 'AD'.
2-Now,please refer the Column 'F'.In this ,Sloc is appearing e.g.AL01,DC01 etc.
3-'Sloc' wise insert the sheet with sheet name of 'Sloc' e.g.AL01,HT01 etc. ( Shown in Tab Colour 'Green')
4-Take a example of one sheet,say,AL01.
a-Automatic Insert Cell no.B4 and C4 from F5 and G5 of the sheet 'PhyInv'.
b-Cell No.B5,C5,D5,E5 and F5 from C4,D4,AB4,AC4 and AD4 of the respective 'Sloc' i.e.AL01.
5-Insert a column in each sheet i.e.'Phy-Qty' should insert with pixels of 90 and appear in column 'G' only.
Is it possible through VBA Codes?
Insert multiple sheets after convert raw sheets into main
-
- 3StarLounger
- Posts: 354
- Joined: 27 Oct 2013, 15:11
- Location: Gurgaon INDIA
Insert multiple sheets after convert raw sheets into main
Regards
Pradeep Kumar Gupta
INDIA
Pradeep Kumar Gupta
INDIA
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Insert multiple sheets after convert raw sheets into mai
Pradeep, that is a very big request. The goal of these forums is to help people if they get stuck, not to create a complete application for them for free.
I wrote a macro for you this time, but you can't count on such a big request being fulfilled next time!
I wrote a macro for you this time, but you can't count on such a big request being fulfilled next time!
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 354
- Joined: 27 Oct 2013, 15:11
- Location: Gurgaon INDIA
Re: Insert multiple sheets after convert raw sheets into mai
Thanks for the painful efforts.You have done an excellent help.Glad.
Regards
Pradeep Kumar Gupta
INDIA
Pradeep Kumar Gupta
INDIA