macro - help

Hello My Macro problem to solve is like this I have a One Sheet with name " Input_Sheet " list 4 colums wide Col1 (A) Defines name "PeterE" up to 50 names Col2 (B) ( DefineType) GG or YRK I have 2 TemplateSheet "GGTemplate and YRKTemplate and i need excel to make copy of the sheet for...

Hi There, Greeting for the Day! I Have a Query regarding Run time Error. I have one old VB Script which is used to extract data from a web database. Now if i am running the same macro i'm unable to execute it completely and i am getting the below error. " Run time error '-2147467259...

Dear, I have a worksheet with multiple macros, which access different network resources; the problem I have it that when working from a Citrix environment the network resources are not the same, and I have to maintain two different version of the worksheet, one for each environment. Is there a...

Hi Everyone, I am struggling to create a macro which will import all files from predefined folder having same prefilx. Kindly refer below for more details: C2 = ShareDrive link in which i have files Files Name = Sample 1.pdf, Sample 2.pdf, Sample 3.pdf I have below code by which i can upload...

Hi, Can anyone help on the below macro code. I have the data like below, <tbody> Name ABC Model DEF City GHI Place JKL KM Condition MNO 1st Owner 2nd Owner PQR 3rd Owner Price STU Delivered 11111111 Name XYZ Model DJFHA City SAHJA Place SHJ KM Condition...

Hi there, I have 67 fields in column A and B beginning in A2 and B2 - I would like to take the first value in A2 and place it in D1 and then the value in B2 and place it in E1. I would like to then add a column with "Diff" in F1. This column should be formatted to display a percentage value and...

Hi guys. I have bit of code that clears a sheet, before it does that I have it save to another location (just incase the user pressed the wrong button), my question is, is there a way to notify the user hat the save is succesful before thy carry on? Here is hat I have already. If...

Hi I know this tittle makes little sense but here goes so I ave a few macros that clear the many sheets have for new data entry. What I want to do is to have the macro auto save with a new name in another location. I can get it all working but the after the auto save, the new save is opened...

I want to save as my file based on value in cell. This value is date calculated by formula. In the same time if this file already exists I want to add _2 to file name. This is what I have so far, but it doesn't work with Formula , neither I know how to add 2nd save as. (Sorry I could not find...

Hi there, I have a macro that works fine but it seems everytime I do other work and come back to it I get this message "sub or function not defined". I have debugged it and get the following, this is the macro. I am using a Mac computer and suspect the problem may be related. Sub...

Hiya and happy new year. I recieved excellent help with my macro code last year, and i have dissected the code to see if i could not learn how it works and to an extent i have managed to :) However, I am struggeling to add inn new code into the existing one. I want to add inn bold font for the...

Hi Introducing myself, my skill in Microsoft excel is very basic. So my coding skill is minimum. I am creating a simple system to track collection Tin time In and Out. Below are the concept. The tin number is fixed and is converted into barcode. When I press on the Time Out button, and scan...

Hi, This Macro code won't list all the Argument Descriptions, it only list the first description in the array "ArgDesc (1 to 2). How do i list all the strings in the array "ArgDesc" ? thanks Sub DescribeFunction() 'This can be used to add help text to each function Dim FuncName As...

Hi Guys, I'm trying to create a macro where cell that has "0" value will be separated. <tbody> Code Name Score 1 Score 2 Score 3 Score 4 Score 5 Score 6 01 John 98 98 95 95 93 90 02 Ben 96 97 94 93 93 90 03 Sean 0 0 0 0 0 0 04 Carl 90 0 90 0 89 0 05 Tim 0 0 0 0 0 0 </tbody> End...

I have a spreadsheet which has been amalgamated from few other, as such the data is not as I would like but the owner will not amend the data. I need to create a search engine of sorts using partial matches. I have the following formula for the first and second matches and they work fine but I...

I am using Excel 2007 Is there a way of seeing or getting the exact position coordinates of a object on a worksheet, maybe a macro that can return or display the coordinates into a cell or on the clip board? The object is a option box called "OptionBox1" What I mean by exact position is the...

Hi I have the following code in a macro that creates sets the value of Cell B25. If Range("B23").Value = 2 Or Range("B23").Value = 3 Or Range("B23").Value = 4 Or Range("B23").Value = 5 Then run code <run code="">This works well but I now need it to do the following so it runs different code...

Will someone please help me with writing of the code for a macro? I would like to run it on a newly opened document. Basically, I want the one column to use all of the rows which contain the same numbers, to give me a total of the corresponding rows' column. E.g A1,A2,A3,A9,A15 are the same (...

Hello Everyone, Hopefully this is an easy fix. I have a large file that I backup every 30 minutes due to it corrupting frequently. I have created a macro to save a new version of the file with a variable name (based on date and time) as follow: "YYYY-MM-DD-HH-MM_FileName.xlsm". It works out...

Hello all, I'm having trouble with a chart that is being built within my macro. It builds the chart just fine, but the two sets of data I want on the chart are 2 different columns and when the macro is done running instead of B25:B(LastRow) and F25:F(LastRow) being selected it has...