dynamic cell

Good day all! I'm trying to make a goal seek function but the change cell target is dynamic based on a certain cell. Hoping to have some help or improvements on the below. Thank you! Sub GoalSeek() Dim Answer As Integer Answer = MsgBox("Run values?", vbYesNo + vbQuestion) If Answer...

Hi everyone, I created a textbox and linked to the cell if i copy paste the whole row the textbox2 goes the previous linked cell In Row 5 Textbox1 linked to E5 Textbox2 linked to F5 Textbox3 linked to G5 Textbox4 linked to H5 <strike> </strike> Now I am selecting the Row5 and pasting it...

Hi all, I have a pivot table that has adjacent columns that work independently of the pivot table. I linked a drop down that users can select from to to control how the pivot table is filtered. I want to Autofilter out the rows that are blank after the user selects from the drop down, but it...

hi everyone, I am trying to find out if there is a way to have an image automatically appear in my cell once i enter a value. For example if it enter the number "1" i want a quarter circle to appear in that same cell, if i enter the number "2" then a half circle appears in that cell and so on. I...

I'm trying to use a macro to insert a formula. But the formula needs to reference the current row and column. Can someone me understand how to do this? "R[-126]C1" - should be - $a & current row "R2C" - should be - current column & $2...

<tbody></tbody> <colgroup><col><col><col><col><col></colgroup><tbody> Player (Filter) Competition (Filter) Venue (Filter) Bonus Gross Bonus Vardy EPL Home 50 50 Huth FA cup Away 30 80 Fuchs Carling Cup Home 25 105 Gray Champion League Home 70 175 Vardy Champion League Away 100...

hi Lets say I have a value of 5 in B1 column and I want to set value of A"X" cell where X = 1 + cell(B,1).value so in this case I want to set value of A6 cell. If B1 has 7 then I need to set value for A8 cell. Any help Much appreciated thanks

Hello, I have one worksheet that is referencing the second. The second sheet has a column for each date and I want to know if a value was entered today on row 8 for example. If there is not a value, I want it to return blank, but if there is, I want it to display the value in a cell that gives...

Hi Excel gurus, I have the following issue and was wondering if someone could help me. I have columns of data but there are some #N/A's in column C and D, if there is an NA in column C then there will always be an NA in column D. I would like to place a vlookup for all NA cells in column D and...

Hello, I am new to macros and VBA so I apologize for my poor explanations. The issue is that the spread sheet I'm working with has dates which are incorrectly read and filtered improperly. When I go to filter the dates, it lists every single date in the column instead of by year, month, and...

Hi Team, I would like to select auto filter with dynamic content text (this will change every time but same column). This is required to integrate into in my main macro, if you can give input box where I can input the required content to filter and same should get filter in the sheet. The...

Hey all, I have a data feed, that provides a constant changing stock market price. I am trying to capture the price every hour to a different cell. For example Cell with data feed, feeds prices "100.00,100.01,100.20,101.00 " between time frame of 9:30-12:30. I am trying to format the data...