new sheet creation with specific information

[Swapijs]

Hello, everyone.

I have got problem with few macros creations, hope you will understand and will be able to help

help1.JPG

1) I want to create macros, which automatically creates new sheets with names from "ID" column with all information, for example sheet with name "1" will have 2 rows with all information like in picture.

2) in F column find specific names and in next sheet copy just value (for example if in column F it contains information like "Next business day" then in new sheet it just shows "N2", if Same business day, then "N1"

3) macros for dates, if the period is year, then copy just "year", if the period is 3 years, then copy "3 years"

Thank you in advance.

Best regards,
Arturs.

[sintek]

Hi Swapijs

This code should get you started to create the sheets based on cell value

Please Login or Register  to view this content.

[sintek]

This part copies the info to the required sheets

Please Login or Register  to view this content.

[sintek]

Don't understand this part:
2) in F column find specific names and in next sheet copy just value (for example if in column F it contains information like "Next business day" then in new sheet it just shows "N2", if Same business day, then "N1"
1. Copy value in what next sheet and what in new sheet

[sintek]

Here is a sample with the result from the above codes. Edit the file by showing a result of what you mean.

[Swapijs]

Thank you for fast reply. Great.

About this one: 2) in F column find specific names and in next sheet copy just value (for example if in column F it contains information like "Next business day" then in new sheet it just shows "N2", if Same business day, then "N1"
Sorry for not being clear.
So, if in column F the description contains words "next business day" or "same business day" then in next sheet, which you created with that macros, for example in column L will show value N2 or N1, N2 for Next BD, N1 for Same BD? Hope you understand now.

And for date the same, that in next sheet in some column it shows value "year" if period from start date and end date is year, "3 years" if calculated period is 3 years.

[sintek]

Hi Swapijs

This code includes the "N1" or "N2" column Populate

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I have no time to add the other code...will do so soonest.

[sintek]

Herewith the final code for your requirement...The subroutine Call CopyInfo. I am almost certain that there is a simpler way, however, I too am still learning lol.

Please Login or Register  to view this content.

[Swapijs]

You are beast. Thank you!!!

[sintek]

Glad i could help. Thanks for the Rep points.

[Swapijs]

Hmmm, but there is some problem with it, when I copy on my original report file.
Do not understand, what is the problem.
I am so lost here, can not find anymore, how to add attachment

ok, so in attachment you can see, that original report is on first sheet, and then I create formated in sheet1 with my macros. And then I want to lunch your macros, but it is not working.

[sintek]

Hi Swapijs

Your above attached has no code.I have attached a updated version with the code.....I used Column Q & R to fill N1/N2 and 3Years/5Years etc

Open file
Enable Macros
Press [RUN MACRO]