vba -help

Hi, I am using the following VBA code to move/fix a selected chart to a specific location on a worksheet. The code runs fine, but I end up with 2 duplicate charts: 1 in the new position, and the original chart in its original position. I would appreciate any help in how to fix the code to just...

Hello, I am relatively new to VBA, and i need help with what i think is a fairly complex macro. I have a force testing machine that saves a spreadsheet full of data about what the force measured is at any one moment of time. I need a macro that goes through the columb where the force is on...

Hi, I have built a relatively large macro that I am now breaking down into chunks to re-edit and improve my run time. I am trying to write a code that will copy all cells in tabs from a saved workbook and paste them into new tabs in the active workbook (which will have a different name each...

I am trying to make my macro open a new workbook and paste all the rows that have duplicate values. I want it to create a new workbook for each set of duplicate values.More specifically, My code is suppose to select cells based on a datediff value of 2, group all the cells with the same unique...

I am trying to create a macro that copies and pastes data based on two things. The datediff value I specified and the policy number. There are tons of policy number that are added and changed constantly. Also, is used for multiple rows. So if I wanted to select all the rows with the datdiff...

Hi, I have written a workbook_beforeclose code that updates another workbook and then change a cell on the workbook with the time updated and lastly opens a msgbox telling the user telling if it has been successfully updated or an error occurred. Currently, the "save changes" dialog would open...

I am trying to finish a macro by sorting a worksheet by the most recent date. The beginning of the macro takes data from one worksheet (ws1) and pastes it to a new worksheet (ws2) along with a time stamp (=IF($B2<>"",IF(A2="",NOW(),A2),"")) in column A. So column A is filled with formulas that...

Basically, I have a folder with 20 excel files (each excel file has only 1 spreadsheet). I want to convert them to PDF with the same names as the excel files are. We use CutePDF Writer. Can anyone help me with a VBA code? Thank you so much.

Hi, I import data from a raw cvs file and run formatting macros. However i want a unique number on each row in the A colum which will be used as a primary key in access. I have made the formula to generate a unique number, but i need a macro to drag down the formula to the last populated row...

I have data in columns A-O. I am looking to build code that compares items with the same common value (classification code) in column B and returns the data in rows A-O for only those items that have a value in Column O of greater than or equal to $0.15 for the like value (classification...

Good morning, I am trying to hone my VBA skills, but I can't seem to wrap my head around this key concept. I would like to save the contents of a cell (It's a title) as a variable in a form of a string, then copy its contents into another cell. Here is what the code I have put together...

I have 3 tables all in one worksheet that are linked to source data which is refreshed daily. Each table has the same column labels and I would like to stack them into a single table using vba. I currently have 2 problems: I would like to copy from the second row down in each table to the last...

I am very new to the whole concept of VBA and am having trouble figuring how to copy the contents of three cells and having these contents pasted into three cells in a column. I want a macro that copies the same three cells (B5, B10, B16) and pastes them in E1:E3 the first time it runs, F1:F3...

https://docs.google.com/file/d/0B4AdUEYBpN4dSm5TLVY0NWtmXzA/edit?usp=sharing Hi thank you for taking the time to try and help me with my query, I am attempting to feed through data form a master sheet to an additional sheet depending on the choice a user makes by selcting from a drop down on...

Hi guys, I gotta serious problem here.. any kind of help is much appreciated!! I have two huge text files (130 MB)each with thousands of records in each. I need to compare the two files using vba or by any means and generate a spreadsheet which includes the header and with two additional...

Below I have the code and pseudo code for the Case portion which is my problem - I am unsure how to word it properly - I have looked up and read hundreds of examples but keep seeing different formats so get more confused. Basically I am doing the same thing over and over - but with new cols...

Hello All, This will probably be an easy request for you. I am currently running a script that filters a rather large report I run to a manageable size. It runs from around 40000-50000 rows down to 2000-5000. Is there any way of speeding the script up? It takes about 20 mins to run...

I'm trying to develop a function to locate a date in a specific column in a spreadsheet (Excel 2010). I've tried lots of variations but still get "Nothing" as a Find result. The Worksheet (Sheet1) has column "B" formatted as "Date". In B2 I have "=NOW()". In B3 to B30 I have "=Bx+1", so each...

I am looking to modify the following code so that only B and D are copied from sheet 2 AND the results are pasted in c and d in sheet 3. Any help will be apprecaited. Thanks Private Sub Worksheet_SelectionChange(ByVal Target As Range) Sheets("sheet2").Range("b1:d10000").Copy _...

Hi, I am new to the forum, but have been using it quite a lot to learn more about VBA. I am trying to write some code that will check a range of names within a worksheet and if there is a sheet with a name from the range excel should ignore it and move on to the next range. If no such worksheet...