ways

Hello folks. I want to be able to see how many characters I am typing into a cell as I type. I know there are many ways to see the length after the data is entered, but I need to see the count 'in-flight' if possible.

I was wondering if someone can please help me on best way to use parametirized SQL query and bring it to Power Query. I have access to SQL server with known connection string. SQL is long and needs to use specific input parameters (project numbers) in it. I don't want to have them changed each...

Morning, I have a code which should be deleting a selection of cells if the word does not start with LMK or DUB or ORK but it seems to delete it even if it does, can anyone spot the error of my ways please ? For i = LastRow To IRStartCell Step -1 K = Cells(i, 18) If K <> "DUB*" Or K <>...

Here is my Pivot table Part 2 issue. multi sheets will appeared when clicks are done on the Pivot Overview sheet values. Ques: is there any method or ways to "control or deal with" such additional sheets from appearing ? Or we just have to manually deleted any sheets thats pop up after...

Hi, his s the code I am using but where it says =range("C5") I want to add another cell like H1 but I must be blind and can not find it on here. I have tried multiple ways but just cant figure it out. sorry Sub saveaspdf() ChDir "C:\Users\he138642\Desktop\Test INVOICE"...

I need to know how to write the following: =IF(3rd digit in cell J2="2","2-10051","1-10031") I do don't know how to obtain the 3rd digit. I tried researching this and tried several ways but got "error" or "false".

I would like to be able to format a cell for time in hours and minutes with the user entering either only the numbers or numbers with the colon. I can do "0\:00" for number only entries, but not both ways. Would also like to do the same in a numeric cell with thee decimal places Thanks

Good afternoon everybody. i have a form that runs off some search sub functions in VBA code that i wrote, that include various ways the user can search results from an excel sheet. the excel sheet has 3 columns that are populated with various dates. i would also like to include a search by...

I think I'm getting confused with LIKE and Regular Expressions. MyString contains a backslash followed by any 4 digits. if MyString LIKE "\" & "[0-9]" then... is failing. I can think of many ways to resolve this but keen to know where I'm going wrong. Thanks.

Hi, in the formula below when I insert a row the reference F6 changes to row 7. I would like to lock row 6 but have F change to G,H, etc. I see online a few ways to do it with indirect or maybe row function but I can't get it right. Any help would be appreciated. Thanks...

HI All, I know it might sounds silly but Im looking to round up or down below formula. I was trying multiple ways and still excel not rounding up this :( IF(K10="Order",((SUM($J5:$U5))/(COUNT($J5:$U5)-COUNTIF($J5:$U5,0)))*X8,0) result in this example was 935 Thank you for any ideas

Hi! Can you help me guys to write a VBA code: Need to select a range as I please, in any sheet , then sort it By "D " Column. Tried many ways, can 't get it done. Thanks as always!

Hi I expect the answer is No as I can't find it with Google, but is there a non-VBA way to update a cell with the date a file was last modified? I know there's a myriad of VBA ways but a User wants a non-VBA version, something equivalent to =INFO() or =GET() Cheers

Hi all, I am trying to write a vba to generate unique ID numbers. This number needs to display in cell "I15" and cannot have already been generated. The unique ID will either need to start with "NHS" or "MAN" depending on which the user is requiring. For example, the ID would look something...

Hi Guys, I need your expert help in one formula. So in below table i have headers,"YES" &"NO" and value of the respective YES and no. What i am trying to achieve here is in input cell when i enter Yes so it should display all YES value in single cell (it should be like...

I've got a data dump from a freight carrier that has columns for ship to /receipt to addresses. The issue I have is that 1 address can be listed multiple ways. For example, 123 East, 123 East St, 123 East Street. I have a list of the proper addresses. How can I go about populating the...

Hello guys, My company has a huge VB, wich contains of 15000 lines. Now this is connected to a access db, but because it needs to connect to a Maximo environment, it need to change to a sql database. What are the easy ways or hard ways for me to change this. Or is there even an option to...

I have the following line of code in my macro but it will not work. I keep getting that error message along with "Unable to get the VLookup property of the WorksheetFunction class. After guessing and trying many different ways to fix it, I've given up. Any help would be greatly appreciated...

I’m still working on my workbook for the school I oversee. Iam looking for some more help though as I’ve hit an end to what I know and I’mlooking for ways I can make the operations easier for whoever comes in nextafter me. So far I have multiple spreadsheets, adobe, and word documents that Imake...

Is there a rational reason why the board requires that I wait 3 seconds between clicking on Like this post and Thank you for posting this? For that matter, is there a rational reason why there are two ways to acknowledge a helpful post?