macro - help

Hi Guys, I'm still learning VBA and currently working on a project. Basically, I need two add additional 2 rows if the score is zero and add a header as "Zero Score" which you may see below: Name Team Score Ana Volleyball 25 Ben Basketball 36 Mike Basketball 12 Che...

I have 2 workbooks, Personal and Office and they are not interchangeable. I can't seem to isolate the macro I created for each of them. Each unique macros should only be accessible from it's relevant WB, but I'm doing something wrong because this is what I have this...

Hello Everyone, I am looking for some advanced level help which requires knowledge of Microsoft Excel & Visual Basic (Macro). Here is my problem details: I have a sharing folder in sharing drive: sharing folder address is “G:\User\Log in Dump”. That folder contains so many folder which...

I am trying to create a VBA macro that will look at the information in column "A" and determin how many cells it needs to shift the information right for a BOM. Current data output <tbody> 0.1 PN1235 Bike ..2 PN2345 Handle Bar ...3 PN3456 Metal Frame ....4 pn4567 Stainless...

Hi Everyone! I need help creating a macro that does the following: Copy column I and paste the values there In column I, If there is a space before “OZ”, “PK”, or “CT”, delete it If the W column has “OG” in it, type “OG” at the beginning of the cells in column F Thanks for your help!

Mr. Excel I am looking for a macro to insert all of the pictures from a folder who's address is derived from multiple cells. Picture location is as follows: S:\Quality\QA\Warranty Photos 2017\ "cell N4" \ "cell K4" \ "merged cells J3 and K3" All files in that folder will be ".jpeg" Image...

Hi I want copy a data range in column G starting with cell reference G2 to the last row, the last row of the data goes to say 1000 rows and I want to paste the copied range in column J starting with cell reference J2. now my question is if next time the number of rows increases the code will...

I am new to Mr. Excel, but I have found some helpful things in the past via google searching. I am hoping I can get some help directly associated with my dilemma for a personal project I am working on. I'll try to be as accurate & thorough as possible. Currently in my excel workbook I have two...

Hi Friend, I am trying to gather particular details from a bunch of workbooks located in a folder. Suppose I have a folder "PI 17 - 18" on my desktop which contains around 370 Performa Invoices. Now I want to collect only few details from each perfoma Invoice in below Format, <tbody> Agency...

I am new to VBA and using Macros. I need to write a code that will take the following excel template and create a word document out of it. The excel file has 7 different sheets in total that I will somehow need to all pile into one single code to spit out a neater word document. The image below...

Hi, I am writing the excel vba code for Login functionality. Somehow i have searched this forum and written the code. But i am getting "Automation error: Unspecified error". Please help me to resolve this . When i do debug the yellow marker show the line "Set doc = IE.Document " which is red...

Hi Guys, I am very new to pivot tables and I was just wondering if anyone can help. I have a pivot table set up at the moment for out of stock orders. Report Filter - Account number Example : 12008003 Row Labels - Order Number Example 818042187 Row Labels - Item Description Example Apples...

Hi All, I need a help where I have the numbers in column B but they are not in the number format. So I want the moment my macro paste the data in column B, it should convert that column in number format. I have tried multiple time but it only paste the data in as usual format. Kindly advise...

I want the help in one of my excel dashboards where i need the automation. I have attached 3 document as per the below:- 1.My Dashboard data 2.Amit_Team Data 3.Harshad_Rec data I want the button to be set into my dashboard data file and do the following:- 1.It should open the Amit_Team Data...

Hi, having never used Macros before I wanted to use one to be able to multi-select options from a dropdown list in Column C. Having googled, some kind person had posted the VBA code and I opened the VBA editor, pasted it in and hey presto it worked! (See code below question). Anyway, I then...

Hi, I am working with the following code in order to identify if the selected values are present in "Column B" of other worksheets within the same file. The issue I am trying to solve now is that it just colours the cells with the SAME value but it does not identify those with the contained...

Hello. I'm currently working on a file as a way to learn excel and brush up on some skills. However I have gotten to a point where I need help. I have two sheets I am working with. Sheet1 has two buttons. One is "Win" and the other is "Loss". When selecting the "Win" button, I am wanting to...

Hello, I need help writing a macro that adjust my axis min and max bounds automatically with data validation. I have the macro below currently but it only makes adjustments to the current selection. How can I get the macro to automatically run every time I change the drop down choices. Sub...

Hi Everyone, I am looking for a urgent support from anyone who can helps me. I am familiar how to work with excel and macro's. But right now, my problem is little bit complicated. Below is my problem details : There is 3 excel file in our office network sharing server. 1 excel file is called "...

Hi, I'm looking for a code/macro to modify Data1 in such a way so that it resembles the final result as shown in Data3 below: Data1: <colgroup><col style="text-align: center;"><col style="text-align: center;"><col span="6" style="text-align: center;"></colgroup><tbody> A B C D E F G H...