I have a master sheet which contains several line items and 4 deal templates. I want a macro to loop therough each line item in master sheet and create copy of 1 of the 4 templates depending upon 2 conditions ie asset type and trensaction type ie buy or sell.
Any help is really appreciated.
Hi, deepsi1,
you should clarify if you want to copy the data into the Columns A to D of the new sheets or into the yellow fields (if so then why are there 2 for Name in the Gsec sheets?).
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi,
I want to copy the data in Sheet1 in Columns A to D in New Sheets in Yellow Marked Fields in newly copied sheets.
Hi, deepsi1,
give this a try:
Ciao,
Please Login or Register to view this content.
Holger
Hi Holger,
That works great. Almost what i wanted. But a slight change is required. I am attaching the file with the result.As you will see in sheets M17 and M18 the units and prices were not pasted in Correct Position. The code used the position for Gsec Pur and Gsec Sale sheets thought they were not. (they are in different rows in GSec sheets and Non Gsec Sheets)
I request you to please edit it for me.
But otherwise a marvelous code.
Thanks.
Hi, deepsi1,
please alter the code like this:
Ciao,Please Login or Register to view this content.
Holger
Hi Holger,
Sorry to bring this up late, I need a little extra bit.
I may have to run the code again and again as data comes to me in bits and parts. So what I need is when i add data to sheet 1, if the sheet for deal id already exists it should skip to next line , such that it will move to additional data in sheet1 when i run the macro 2nd or 3rd time.
Thanks a Ton. The modification worked perfectly.
Hi, deepsi1,
either place a boolean value next to the data already worked on or use either a loop or try to activate the sheet to find out what action needs to be taken (skip or add a new one). IŽd go with the additional information in the original Master.
Ciao,
Holger
Hi Holger,
In case I add additional columns (fields) in Sheet1 , say column G and H containing additional values that i need to paste in the Deal Sheets in Cell F7 & G7, how do I edit the code.
Hi, deepsi1,
add the cells to copy and paste in the Arrays:
The copying will be done by the length of the Arrays but the cells would need to be directly side by side (no other data in the columns from A to F). If you want other values in there you would need another array holding the columns from which to take and in which order.Please Login or Register to view this content.
Ciao,
Holger
Hi Holger,
That was really quick. You are brilliant. I tried it and it worked perfectly.
Can I request you again to provide me something for "if the sheet for deal id in Sheet1 already exists it should skip to next line , such that it will move to additional data in sheet1 when i run the macro 2nd or 3rd time.". The reason being that even though I will get the data in Parts I receive consolidated data not just the new line items. I know the code will become heavy and too complex, But I would really like to see if it can be done.
Hi, deepsi,
maybe use another Boolean for the check of whether the sheet already exists or needs to be copied. Code is untested:
Evaluate could be used to check the existence of the sheet instead of activating the sheet like shown in the Function above.Please Login or Register to view this content.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks