dynamically

HI everyone i am new here. i am managing school staff data in excel sheets. i want to create dynamically summary of my all staff with detail and summarize. but i don't have idea for creating summary that impress to my boss. plz suggest me in this regard and help to make this summary...

Hi i would like some help with returning column headers based on the highest value in the specific row that will change constantly. Much appreciated! An example would be: <tbody> <tbody> State 16/08/2017 13/09/2017 20/09/2017 27/09/2017 04/10/2017 11/10/2017 18/10/2017 20/10/2017 1...

Hi all, I currently have a spreadsheet with multiple sheets within it. Each sheet represents a work centre. Each sheet contains the dates that a number of tests have been completed. I currently have a separate audit spreadsheet that calculates the difference in dates between each consecutive...

Hi all Done a bit of Googling and looked at things like CUBEVALUE etc but haven't quite worked out how to get GETPIVOTDATA working when some of the values come from cell references. I've had to de-personalise this but basically I have...

I’m trying to create a bar chat that will always refresh to the previous month’s data, but keep the bar chart for previous year the same. My bar chat will have 4 bars: 2015 bar, which will always display data for 201512(dec 2015), 2016 bar which will display 201612(dec 2016), 2017bar which...

I've tried a bunch of tutorials and how-to's, but I keep getting errors. Goal: set the data range of a chart based on user input. In my example, I am charting some historical data with date on the horizontal (x) axis with a line chart. I want the user to type in a date value (cell B1 in my...

Hello, Can someone please assist me in dynamically referencing a table? If I have a table called Table04.01.17 can I tell excel to look for Table(A3) with A3 with 04.01.17? So the output would be Table04.01.17. So right now I can do =COUNTA(Table03.01.17[COST]) but rather than updating it on...

Hello, I was looking into "dynamically defined names", but am not sure that's what will work for me... I have values changing in column A, and based on that value, the cells in column B (same row) should have a particular defined name. But there could be several possible dynamically defined...

Hellow to the forum Ok, this must be easier than my previous task. I have vba generated below data range from multiple worksheets. Every time i add results, i hit the update button placed in this Master Sheet and automatically clear contents and merge the updated ranges. The next step is to...

Hi, I have Date columns that is dynamically expand or reduce as per date selection by user, my question is how can I dynamically adjust formula, for example my date column starts from Column C, and user select start date is 01-09-2017 (Date Format is DD-MM-YYYY) To 25-09-2017, then the formula...

Hi All, I need some help, I can manage to delete rows dynamically.. but idk on how to delete table dynamically based on criterias with Selection.ListObject.ListRows(x).Delete command example below, how to delete "Bread" - type only using VBA? thanks for the help guys! much appreciate

Hi there, Is it possible to combine the sumbycolor function and hlookup? Here is my data file - https://ibb.co/gkdMYw Summary sheet - https://ibb.co/h3tG0b I'm trying to dynamically calculate the sum for a given month/project/team. So in cell C4 I'd like to calculate the total for Team B...

In Power Query, is it possible to refer to a column's data type? I would like to create a function to trim all columns whose data type is text or any dynamically.

Hello, I am trying to dynamically create a formula in excel. Background: I have created a spreadsheet that users will be populating on an ongoing basis with assessments they are making on a daily basis. To dynamically support users creating a weighted score from their daily assessments, I...

Hi everyone After scouring the Forum for answers, I have come up blank. Can I please pick your more experienced brains on this one? I need to consolidate daily data into weekly data onto the same sheet. Each day data is entered into the sheet and needs to produce a weekly total of product and...

I have the following code so far which uses arrays to add click events for newly generated labels. However, I want to convert this to using collections instead since I have to redim preserve everytime a button is made which is supposively a performance hog. I have tried to convert over to...

Howdy ! My first post on Mr. Excel, so let me know in the comments if I left anything out. I have attached a simplified version of my project which illustrates my problem of creating a chart, when the data dynamically changes quantity, the graph gets thrown off. You can see that if you change...

Hello guys, I have data from A2 to A14 in an Excel sheet, for which a linear graph can be displayed next to the data. I wish to plot the same graph but while I have the data ONLY in A2, which changes subsequently (and there is no data anywhere else in the worksheet). That is, as soon as the...

I need assign the Click event of a label that was created programmatically. My code is working, but still can not assign the Click event dynamically: Public Sub Create_Label() Dim ctl As Control Dim pic2 As String pic2 = "C:\Documents\Pictures\Convert 24 bits.bmp" Set ctl =...

Hello guys, Inside a userform I am setting a multipage page with multiple textboxes (lets assume 3 textboxes) and I would like to press the Tab key on the last textbox and make it focus the first textbox (so that I can type inside the first textbox). For kicks these textboxes are added...