dynamically

Hi, I have two tables in two different worksheets under the same workbook. Table 1 & Table 2 I want to create a function that will take table 1 & table 2 as parameters. Copy cells from table 1 to table 2 but we have have 2 questions: Which column to update and which row to update to know the...

Number 1-21, randomized without repeat showed in the left column (I learned how to do this part), with a row of comment/label depend on the randomized result (say, the 4th maximum of 21, 2nd minimum number of 21, dramatic increase section from the 3rd number to the 6th number, etc). How can I...

I'm trying to dynamic align column B to column A, but by matching a substring, and not by matching the whole content of the cell. I have two column, with filenames in each (all with the same format, basically: Show.name.SxxExx.optional.title.source.codec-group.extention), but they might be a...

Hi everyone, I am looking for several days now, how to transpose dynamically unique data. The table I have is that journal! a a b c d b And I would like that Rate! abcd BUT I want to be able to add data in the column journal! that would directly goes to the rate! sheet. Transposing is...

Hi, I have been able to create pivot tables dynamically one after the another and I am also able to provide the gaps of 5 rows between the pivot tables. What I need is to insert a Heading for each of the pivot table. For creating a pivot table, I use the following code. The "PivotTable1"...

Hi All. This is my first time posting. I have a question regarding a task that I need to complete quite urgently. I am reasonalbly familiar with excel and use most of the more commonly-used function and formulas. However when it comes to macros, i have had limited success, not having a true...

Help please, I'm in way over my head. My report runs fine, except when multiple users run it for the same job at the same time (which they need to do often during meetings for some reason). Then it "slows to a crawl and they don't know if it would even run if they waited long enough". Using...

I am trying to create a table of contents for a very long list of items on a sheet. I am using shapes on a seperate sheet to act as buttons, that go to the location on the correct sheet using a hyperlink. I found how to add a hyperlink using a macro, but I can't find how to create a hyperlink...

example: I have sheet named "Dept. 1", "Dept. 2" and "Dept. 3" each containing a list with 2 columns as follows. dept. 1 Dept. 2 Dept. 3 1 account Value account Value account Value 2 120 100 100 1200 110...

Hi! I am trying to streamline the product overview making it easier to view the sales of three different departments in one overview file. How it works today is that a responsible person in each of the departments adds information to an excel file consisting of columns such as order number...