Search results

Thank you very much. I realized too that I could go through similar steps with Table 1 a second time but remove the columns with the text, leaving the Amounts to use in the 2nd column. I appreciate your help. God bless you.

Thank you very much. I tried to do this by going through each step manually in the Query Editor and I got to the last step #"Appended Query" = Table.Combine({#"Removed Other Columns", Column5, Column8}) And I couldn't do that on the Ribbon. I selected 'Append Query to New' but I could only...

Hello, I am using Excel 2013. I'm not sure that this needs to involve VBA, but I am receiving Excel wksheets from clients who have many data sets randomly scattered across their wksheet, and I have to create a structured data list from those data sets in another workbook called Analysis. I...

Thank you very much, Kenneth. That works! I just expanded it to add the links to the other cells. Thank you, again, very much. Sub Main() With ActiveSheet .Hyperlinks.Add Selection, "", .Name & "!" & _ ActiveCell.Offset(0, 18).Address, , "Jump" .Hyperlinks.Add...

Thank you for your reply. I tried your code to populate just one cell and it doesn't work. I will list what it does: - it puts the sheet name and cell reference in the cell and not the text, 'Jump' - when I click on the link it gives the same error I got before, 'Reference not valid' - also I...

Hello, I want to be able to add hyperlinks to 4 cells in a worksheet in the same row (except for one link) across columns. Details: - I want to select a cell in column D and have it add a hyperlink to that active cell called ‘Jump’ that will jump to a cell in column V--still in the same row...

It works now. I added cell.Formula = "=index(Sheet1!" & IndexTable.Address (True,True) & ", Match(" & cell.Offset(0, 4).Address(False, True) & ", Sheet1!" & MatchTable.Address(True, True) & ",0))" This makes the formula like =Index($E$2:$E$2,Match($H2,$E$2:$E$2,0)). There might have been some...

Thank you for your reply. I tried running this code and a dialog box opened when I get to the 'cell.Formula = "=index', etc. named 'Update Values Sheet 1' and it stays stuck. If I press OK, it closes briefly and then pops back up. I have to finally force shut down Excel. When I open the Address...

Yes, using Excel 2013, this is a continuation of a thread I posted earlier to try to speed up code I'm using on 2 sheets of data: https://chandoo.org/forum/threads/excel-freezes-looping-through-many-cells-to-match-criteria-btw-wkbks.36033/#post-216132. I have since moved the data to 2...

Thank you for the help!

You are correct, Narayan. On Monday, I think, I read that you can use Vlookup in VBA. For some reason I didn't think you could. I'm going to try to redo my code and add the Application on/off code the other replier mentioned and maybe copy the Billing data to a wksht in the Address wkbk to make...

Hello, I'm using Excel 2016 and trying to match addresses btw. 2 workbooks, the Address and a HUGE (60,000 to sometimes 300,000 row) Billing workbooks. The Address wkbk will be populated by data from the huge Billing wkbk, as follows: * When I find a match, the code will populate the Address...

Thank you, Chihiro. I didn't think about using Offset. It works very well. Thank you so much for your help.

Hello, I'm using Excel 2013 to try to color a row gray if column F contains the phrase 'Existing Home Component Set' AND if column H contains the year 2017, the dates in column H are in the format mm/dd/yyyy. 1) I tried changing the SrchRng to equal Range("F2:H" & lastrow), but it does not...

The same reply goes for your answer: This works perfectly. Thank you (both) for your help!! I very much appreciate your time and help.

This works perfectly. Thank you (both) for your help!! I really appreciate it.

Hello, I have code (see below) behind a toggle button on my spreadsheet that, when clicked the 1st time, it will go to column AL (the Comments column) on the same row as the selected cell (it will also change the caption of the toggle to say. '<<<Go Back to Node A'). When clicked the 2nd...

Thank you very much, Narayan. This was the line that worked! On the other line above, I received a 'Run Time Error 438: Object does not support this property or Method.' Also I removed the rng.Select lines that you removed under '-----Clear Formatting and '-----Clear Conditional Formatting...

Hello, I'm using Excel 2013 and have code that highlight rows based on when the value in column E (House column) changes and if the Week column (column D) changes within that hub, then it highlights that row, too--alternating between light green and no color. The problem: It doesn't highlight...

OK, thank you. I think I see on the Office Dev Center site that Intersect just says the parameters are Arg1, Arg2, etc. I see, thank you, again.

Thank you, both, so much. I am learning VBA and I kept going over and over and didn't even see what I was saying--'r' can't be '1x1' and 'Complete'. Can you tell me what is the significance of switching the order within the Intersect parenthesis?: For Each Rg In Intersect(Target, [O1:O210]) to...

Hello, Thank you for your help. I'm using Excel 2016 in Office 365 and have been trying to work on code that will trigger a msgbox when you add the word "Complete" to column O, but only if the word "1x1" is in column H. I want to try learn more of VBA, and I wrote this code below based on a...

Thank you, Marc L. I appreciate your help. I am trying to learn Excel VBA and I appreciate your help on streamlining the code. Thanks.

Thank you, Chihiro. Your code worked, as well. I was asking Monty, but I want to ask you b/c you mentioned it: So it didn't have problem with my variable, 'wkshtname', but it seems, like Chihiro says, that the autofilter was not turned on, I guess? I just thought those kind of errors were b/c a...

Monty, Thank you! It worked, and it is a much more streamlined code than what I had. I was surprised b/c it looked like it would sort c first, then d, but it didn't. This is like the sort where you sort one column at a time and have to do it in reverse vs. the custom sort with the dialog box...