I am trying to create a vba code that gives me the numbers I have to put in the demand plan adjustments table to reflect a ratio of 2.5 and 3 in the budget volumes & pts consumption ratio. Find below my data and the code that I tried

I am trying to create a vba code that gives me the numbers I have to put in the demand plan adjustments table to reflect a ratio of 2.5 and 3 in the budget volumes & pts consumption ratio. Find below my data and the code that I tried

I’m a beginner in terms of using the automation feature for Excel. Now I have used the automate record feature to create PivotTables for a report. However, in the script it didn’t sort the data from largest to smallest, which is my first problem. My second, is once I sort it manually, I would like to have an automation feature that would take the top 10 from 2 general categories in each PivotTable and insert them into tables on different sheets. However, sometimes these categories don’t always have 10 values. Is it possible to limit the number of cells it copies and pastes to the tables?
enter image description here
enter image description here

Im in a workbook with 2 pages (one called character sheet and another called combat). I have a dropdown menu pulling information from the character sheet and putting the value in cell E2. Cell E2 have been merged and centered from E2:G2. I’m trying to run a script that will see that the dropdown menu has changed and paste a bunch of info below it.

i want to plot below data set.

can anyone help me with this, pls?

Is there a way to copy the body of an e-mail into excel sheet using VBA?
I would like to filter my Outlook e-mails by either the subject or e-mail address of the sender. Then I would like to copy the body of the e-mail and paste it into excel sheet. It would be good to filter the e-mail by sender and choose only the latest e-mail.

I’m trying to delete some shapes that have macros attached and only leave combobox when copying the workbook for the end user. All my comboboxes start with Cbxxxxx.