excel & vba

Hello Mr. Excel community, I have a small project that seems to be beating me and I need your help. I have a column of data that could be letters and numbers or all numbers (PartNo). I would like to change the value to the first 5 characters (Base5). I can do this as a formula in Excel, but my...

Yes, I'm aware that merging cells in VBA is not recommended and often a nightmare, however it's a necessity for the workbook I'm working on. Please feel free to slap my hand for merging though haha. I'm looking to merge two cells in a column. It needs to be activecell based and not based on...

Have a block of code that utilized .AutoFill several times. One of them returned a run-time error 1004 autofill method of range class failed. Couldn't for the life of me figure out why the other autofill codes weren't generating errors when they were in the exact same format (and were...

Since I am very new to the excel macro I am trying to develop a code which is able to open the PDF file.But There are some PDF files in my system which are generated by another system therefore those files names change day by day and some figures are included too. As an example,"Process Report...

Hi im hoping someone can help me with this because i am really struggling.. I am having issue with ".CommandText = Array( _ "SELECT * FROM Consolidated WHERE [Start Date]> '2019-01-01 00:00:00'")" it seems to be working fine if i do the criteria on brand or anything else.. however it...

Hi All you Guru's, I need a little help. I have 5 Dependent drop down Lists. Created from the Data Validation. I would like to reset the selections once the user decides to do another selection. I created this code below. The idea is the if the user makes the 5 selections and if he chooses to...

Hi Friends, Can you please review the below code and do let me know where i am lacking. Column C has the dates and i am trying entering the formula " =IF( OR(RIGHT(C2,3) = " PM",RIGHT(C2,3) = " AM"),A1, CONCATENATE(LEFT(A1,LEN(C2)-2)," ",RIGHT(C2,2))) " to add space between timestamp 6:18PM...

Hi everyone, I am working on a project that requires me to expand the acronym in column A of excel and copy the expanded term to column B. The acronyms i am working on mainly revolves around the engineering mechanical side. An example would be: Column A Column B AHU-L8-01...

Hi all. Hope you guys can help me out. Got a VBA process which imports data from a web page and clears cells where the value is less than 0. This works fine so the result is like below. Data in cells A4:C15 <tbody> 114 sev1 0 114 sev2 0 114 sev3 125 sev1 0 125 sev2 0 125 sev3...

Hi All, so i have probably a common question but i cannot figure it out. I am trying to move a whole row based on what is entered in column F. so if i enter "Yes" in column F the whole row should move to Sheet6 finding the next available line in the table. i have the code below that moves...

Hi All, I have a spreadsheet with multiple columns, with Columns "F", "I" and "L" listing scheduled jobs (SJ) and Columns "G", "J" and "M" listing work sites (WS) for the SJ. So, Columns "F" and "G" will define a SJ and a WS and Col "I" and "J" the next SJ and WS etc. These 3 columns "G", "J"...

Greetings I use the following notation to report certain values. >1.000 <0.0001 These values are in units of micromolar. I would like some code to convert them to the following. >1.00E-06 <1.00E-10 I have something like this.. Sub Tidy_IC50() ' Tidy IC50 value if >1.000000 Dim dData As...

I have looked on this site and many others but not finding the exact piece of code I am looking for. Probably not asking correctly. I have a workbook that has a worksheet for each day of the year, each formatted exactly the same an labelled like this "mmddyy". What I am attempting to find is a...

Good day. This is my first time asking a question here. I have a blank workbook that contains one macro. The macro opens a template workbook in the same folder, changes the name of the file (from a list in the template workbook), saves it and then closes the template workbook. It runs through...

I am new to CAML quering a sharepoint website. The code that I have below works great to get the data from a sharepoint website. The problem I have, the admin of the site created various custom views. And the default view is a truncated view of the data in the site. And the query gets the data...

I am working on 'Word Document' where a text is selected and converted into variable let say CCC. I want to transfer this CCC to 'Excel Workbook' Sheet1 in next empty row. I am trying following code but it seem not doing anything: Set CCC= Selection.Range.PARAGRAPHS(1).Range Set...

Hello Experts, I have certain Word document templates which we use for all projects. We also have a Excel template for certain different things. Now, whenever any customer comments or issues are recorded, they are recorded in a defect Log Word template and resolution is updated in that template...

Hi All, I'm new to this blog, so I hope I follow the rules correctly. Thanks for accepting me. I need help setting up a macro/VBA to copy a specific column (G) range "G1:G550", which contains data in some cells and formulas in the others others. The column needs to be copied to the next 50...

I have a table with data sorted into rows for review, rows that are ok and rows that are other, between each data set is a blank row. I want to run a macro that: extracts the data for a person(I've got this), groups the data by review/OK/other , closing(hiding) 'Ok' and 'other' groupings...

Hi Guys, I need to copy and paste data from multiple workbooks and multiple sheets. (name keeps changing of worksheets as well as workbook) I have a code but here I need to manually select the cells. I just want to select the sheet and it should automatically import the entire data in the...