things

Range("F26").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-1],'F:\infestor profiles\UK Holdings BP\[Things things things.xlsx]Sheet1'!C3:C5,2,FALSE)" Range("G26").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-2],F:\infestor profiles\UK Holdings BP\[Things things...

Hi experts! I have a problem with trying to write a VBA code...have tried creating & looked around the web and have so far failed miserably with this. I am trying delete rows NOT starting with three letters - specifically HKG, BJS and SYD. The table looks like the below with the data being in...

Hi I am looking for a list of characters that is used in Excel what for what reason. For example, I know "$" is used to lock a cell, "!" is used to refer to different tab, etc. Tried to google but got different things. Thank you very much

What is the vba for the last row in a table that has things below it so I can't use the xlup?

Hi All I have the following formula that references a row that contains a two digit code, that then automatically imports data into another worksheet based on that two digit code. The problem I have is that this two digit code can be GD or Gd and mean two different things. Am I able to...

I have this macro in two different files. It runs in the first one but when I run it in the second one I get a "Run Time Error" message asking me to debug. I moved things around in the print area and this error message came up when I ran the macro. It was working fine before I moved things...

On my form I have a textbox1 control and this code In Form Activate action2 Me.TextBox1, "fred" Sub action2(tb As TextBox, tt As String) tb.Text = tt End Sub I've tried various things, Inside quotes, with & without "Me" but keep getting Type Mismatch errors. I can't see why this...

My wife runs a fitness group which hosts team competitions. The team individuals get points each day for doing things they are supposed to do. They receive negative points for doing things they should NOT do. The values from each day of the week for the bad things are totaled to determine...

Hello wonderfully smart people! Can someone help or point me in the right direction... I would like to have a list of tasks, say A2:D15 would be a list of things to do. Then F:J would be days of the week. So, for example, A2 is "Inventory Parts" and H7 is "Inventory Parts". As H7 is filled...

Suppose i have two dates one is plan and second is actual plan date is when the job is to be done and actual is when the job had actually done based on thesr condition i want to know three things 1) how much jos asigned had done 2) how much late has been done 3) how much dealy had been made...

I have a question how to set up a scatterplot. I have a table with column A ID’s, column B percentages% and column C numbers. I want to plot numbers against % and show for each dot the ID. I have tried to do several things in the scatterplot add multiple series but ir is not working.

Approximately how many menu commands in Excel 2016 or 365? These would be things like File, Save As or Insert, Table, Pivot Table. I have seen a list of shortcuts and accelerator keys around 400, but they still don't cover a lot of things.

Hey! I have enormous amount of data in .txt which I need to be converted to Excel. Data looks like this: AhAs3s2s@100,AdAs3s2s@100,AcAs3s2s@100,AhKh3s2s@100,AdAh3s2s@100,AcAh3s2s@100,AdKd3s2s@100,AcAd3s2s@100,AcKc3s2s@100,AhAs4s2s@100,AdAs4s2s@100,AcAs4s2s@100,AhKh4s2s@100, (...) Outcome has...

Excel crashed and when it started back up again the ribbon had changed to the new version. The icons have less color and depth, and the tabs are no longer differently colored when selected. I have some visual issues, and this makes it harder for me to find things. I saw an article that said...

Is there a formula/macro that will allow me to remove all carriage returns within a cell? I can't seem to remove them and I've tried a number of things to remove them. Can someone please help if they have a moment? Steve

Hello, I have looked this up online and tried a few different things, but none have worked. It seems to be something many people have done in the past, but for some reason none of the solutions work for me. For example: Sheet2 A1 =Sheet1!A1 I need to fill down on Sheet2 Column A with...

Does anyone know how to make a text box where you can type things that will increase downwards in size to fit the contents? It needs to be at the top of the document, so when it increases in size, it will push other things down.

Hello, I have a formula I inherited and I want to use actual cells to populate this. I don't know statistics enough to know what this says but can get kick started is anyone knows the math? In cell E3 the value is 6419 (the amount of samples I sent out) in F3 where the formula is the value is...

All~ I am looking to write a formula that takes the data from u2:dr2, find the first reference to the number 70, search right to left, and then returns the corresponding date in u1:dr1. I have tried all kinds of things and just can't seem to get it correct. Do any of your brilliant minds have...

Hello everyone, I am very new to VBA so excuse me if my problem appears to be trivial for some of you. Let me explain the situation : I have a table consisting of 96 columns and 160 lines. I have been measuring things in triplicate, so each three columns are concerning the same sample (A B C...