TWB | Python based bot for Tribal Wars | Bot library

I am trying to upload a Tableau workbook to the Tableau server

I am getting the following message

The path to the data source seems fine - when I enter the path into the browser window, I am able to connect to it and it downloads the file without issues

"C:/Users/cmomah/Documents/Projects/Analytics Database/Voucher Statistics Dashboard/Troubleshooting/VoucherStatsDashboard.twb Files/Data/Analytics Dashboard/vchr_cnt_hr.xlsx"

Does anyone have any clue where this error is coming from and how I might be able to resolve it and upload to the server?

Question: Is it possible to use a for loop variable in a function?

I have the following code:

In my workbook I have 2 worksheets: Sheet1 and Sheet2.

In Sheet1 I have the following data set:

In Sheet2 I have the following data set:

I need to create a code that will do the following:

• Populate the score columns ("Score of SpeGro", "Score of PrimSpe", etc.)

For example, for the "Score of SpeGro" column it needs to:

• Search in Sheet1 the column header corresponding to SpeGro (in this case it's column 4);
• The values of column 4 need to match the values in column 3 of Sheet2.
• Only consider the values in Sheet2 with the DIMENSION "SpeGro" (in this case);
• Only consider the values with PrdInd (Sheet1) = PrdInd (Sheet2).

Extra info: I have a INDEX-MATCH formula that works if I only had DIMENSION:

I have values stored in Column B of Sheet #1 and the idea is to copy those values to a different sheet, store them and then remove the duplicate values. I have the following code:

I have the following userform:

Using the code below I can save the names of each selected checkbox into a sheet. The value will be saved in the same column, but on different rows (of course), as more than 1 checkbox can be selected.

I have a userform with several checkboxes. I want to save the ticked checkboxes in different sequential rows of the same column.

For example, if I selected 5 checkboxes then I want to save them in cell(4,9), cell(5,9), etc. I have the code almost done, but I'm having trouble writing a while loop that will make it go from cell(4,9) to cell(5,9) and etc.

Here's my code:

As you can see above, I have a table in a Excel sheet where indication A can have product 1, product 2 and so forth (The prods names are all different depending on the indication, this is just for simplicity!).

In my userform a similar format is presented. I want to basically match the indication name on my excel sheet with the indication name in my userform. If they match, then Product 11 gets A's Prod 1 name, Product 12 gets A's Prod 2 name and so forth.

I've tried the following, but I'm just starting using VBA so I'm sure it probably doesn't even make sense.

I have a Pivot Table with more than 11,000 rows of data and 53 columns. I need a piece of code that very efficiently fetches data from a particular cell in the Pivot Table.

This is what the Pivot Table looks like:

I need to be able to fetch data from particular cells using the three (3) columns to the left as the conditions from picking the correct row and offset to the correct column by using the week numbers 1-50 at the top.

Here's a snippet of my current code (which works, but is probably highly inefficient since I need to this query about 48 times right now.

Hi,

I know this formula here