Content Report Automation

.

Please Login or Register  to view this content.

I accept PayPal

Hi Logit, thank you for your quick response with this request. Appreciate it. I have tried your macro and it is good, however, can you instead include only one button called "Run" so that when the user clicks on that, the column "Content Type" (which is initially blank) is populated with the values based on the conditions/criteria specified above?


Typical Usage Scenario

1. The .xlsm sheet when initially opened should be blank with no data in it except the Column header row and the "Run" button.
2. User would run the report in some other application and would copy the report data and paste it in our macro sheet. Note that the report data would not have data in the "Content Type" column.
3. The user would then click on the 'Run' button. The macro would then compute and then populate the data in the "Content Type" column.

Thank you once again for your efforts!

.
Sorry ... I don't understand the goal.

Sounds like you are wanting to run the reports in another workbook, then paste the results in this workbook ?

Not really. Let me try to explain again. The report will be run in one of our other applications and then exported to a .csv sheet. I will then copy the report data from this sheet and then paste it in your macro (.xlsm) sheet and run the macro by clicking on a single button called "Run". Note that the macro sheet should only have the column header initially and no data. Your macro should then do the magic and populate the column (called "Content Type") with values based on the different criteria explained above.

Let me know if something is not clear and I'll try my best to get that clarified. Thank you!

.
So ... column N (Content Type) will be empty after you paste all of the information in the other columns.

From the information provided in the other columns (J, K, L) you want Column N to determine the type and place the TYPE TERM in those rows.

Is that correct ?

Originally Posted by Logit

.
So ... column N (Content Type) will be empty after you paste all of the information in the other columns.

From the information provided in the other columns (J, K, L) you want Column N to determine the type and place the TYPE TERM in those rows.

Is that correct ?

Exactly bro. You got that right. When I initially copy and paste the report data in the macro sheet, the column N will be empty and after running the macro, it will be populated with values based on the above criteria. Thanks.

.
Addtional macro :

Please Login or Register  to view this content.

Thanks Logit for the macro. I tried this latest one with a different set of data and observed that after clicking on the "Complete Content Type" button, the column "Content Type" only populates for few rows (in my test, it only populated till the 9999th row). Is there some limitation on the number of rows in the macro? My test report data had 66895 rows and the Content Type column had only 9999 rows populated after running the macro. Can you please check this? Thank you once again for all your efforts in creating this macro. Regards and have a great day!

.
Where you see For i = 2 To 10000 edit that from 10000 to as many rows as required.

Hi logit, have you had a chance to check this please? Thanks

.
Sorry for not getting back to you sooner. This FORUM has issues with the server software and at the moment I am not receiving notifications of new posts or private messages. I am told the owner can't do anything about the issues, that 'These things happen and sooner or later it will clear up on its own.'

In any case, here are the instructions for deleting the buttons/code you no longer need:

Click on DEVELOPER tab in menu bar.

Click on DESIGN MODE.

Right click each button, one at a time, selecting VIEW CODE.

When you perform this action on button "PO Item Is True", you
will see the following in the VBE :

Private Sub CommandButton1_Click()
POItemIsTRUE
End Sub

The name of the sub attached to this command button is called
POItemIsTrue. If you double-click on Module1, located on the left side of the screen, it will take you to the location of all the
subs. Find the sub named POItemIsTrue, then delete it. Go back to where
you found :

Private Sub CommandButton1_Click()
POItemIsTRUE
End Sub

... and delete that sub.

Now go back to the worksheet where the buttons are located and perform the same procedure on each of the buttons you want to discard.

Hi Logit, greetings to you. I tried to follow the instructions exactly in your last post and after the last step, I saved the macro sheet and when I opened again, I still see the button. I am not sure where I am doing wrong but if you have got some time, can you please make the following changes and attach the macro as a sheet here/if it is still not possible to attach it here, can you please upload it to your Google drive and share the link with me:

1. Where you see For i = 2 To 10000 edit that from 10000 to as many rows as required. (as mentioned in your earlier post)

2. Remove the buttons on column O

Thank you and have a great weekend!

Hi Logit, have you had a chance to check this please? Thank you and have a great weekend!

Hi Logit, a gentle reminder. Can you please check and provide the sheet based on my comments in Post # 14?