macro 2010

Hi guys, I've started a new role that requires me to fix the mess my predecessor created. My current assignment is to fix the formulas and formatting for over a thousand worksheets, spread across multiple workbooks. Each workbook represents a country e.g. 'England' and each worksheet in said...

Hi, i have around 1000 workbook with same formats in a folder, i need a macro that opens all the workbook and copy ROW 5 text alone and paste this in another excel one by one... i have given a example below of how my excel is.... i need to extract the "Upper Saddle River, NJ" text which was on...

Hi, I'm relatively new to writing VB and I wanted to know how I could pull data from multiple spreadsheets into a 'master' spreadsheet. Basically what I have is 5 spreadsheets that are identical. Identical as in have the same column names etc, not the same data in them! The Master is also an...

I have difficulties in date and time format. Since I always need to change the day/month/year. Usually I just did it manually, however after I found this amazing macro things, I hope I can do it using macro which can save me a lot of time. Here the situation is: I have 16 years (1996-2011)...

Hi! I need a macro that can find multiple identical values in column A, then find the min and max values of column B and delete all other rows. Example: A worker comes to work and registers at 7:55, at 11:00 he registers for lunch and comes back 30min later. At 16:05 he leaves work and all I...

Hello Excel Gurus, I am performing interval analysis with conditional formatting that highlight cells in a row where either an interval was missed or a defect is evident in reporting. Interval misses are red and defects are yellow. I am using the following VBA below in conjunction with the...

I want to write an if statement or VBA to separate the day, month and year. Instead of reading 1/12/2010 I want the 1 to appear in one column the 12 to appear in another column and the 2010 to appear in a separate column. One of my concerns is the first number can sometimes be two digits and...

Hello Everybody, This I my first post and along with that I am a beginner to VBA/Macro. I really need your expertise to help me pass through this hurdle I have been facing couple of days. I have tried alot and went through 100's of post but wasnt able to come up with something concrete that...

Hi, I got a macro that works most of the time with the data I have, but sometimes my data is incorrect and needs to be changed manually. The data is incorrect when in kolom A the text is not ZORS (or blank). I want to let the macro search in kolom A whether there is a value that is not: ZORS...

First off, sorry to ask about runtime error 1004, but I am not that familiar with VBA and I cannot find a solution anywhere that I can make sense of. The problem I get is: Run-Time error '1004' : Application-defined or object-defined error Here is my code: Sub DateInsertion() ' '...

Hello, I am using MS Excel 2010 . And want to create a macro that will edit a cell range based off two criteras . Meaning if cell = sheet name then look for list box item in cell range . user input "date" then search sheet ref and row ref to input data in matching cell. to further...

I am try to get some real estate data off this website but the URL keeps changing. I would like to put a list of parcel numbers in excel and let Excel do the data scraping. The parcel number is at the very end of the URL. Here is a example of a URL: <tbody>...

Hi, First I want to thank all of you for posting and answering questions, it really helps especially for a new comer as myself. I have this task I'd like to get help on: We are using Excel to monitor projects and assign tasks to persons, on the active sheet we will write the details of the task...

Good Morning! I was wondering if someone could help. I have built a macro that takes two reports and runs through to create a few pivot tables. When I run it on one machine, Windows 7, Excel 2010, it runs without any problems. When I run it on Windows 8, Excel 2010 it stops at the same point...

Hi, I used the macro record button and then made a graph from start to finish (on sheet 2, where all my data is on sheet 1). Then I created a button to run the macro, linked that button to the maco I made. However when I click the button to run the maco I get the error seen below Then the...

This may be a difficult question to answer, because I can't supply the exact macros I'm using but I will try to give a good description. Essentially the original workbook has data for multiple sales branches across different categories. The macro essentially makes a new workbook for each...

Hi everyone, Can someone help me with a macro? I need to take a list of projects and combine this with a template listing out descriptions. Each project needs to have the same descriptions and I need to output a new worksheet after. Here's an example: Project (Columns A & B): A...

Hi. I am needing assistance in creating a macro to find and replace contents of cells from one sheet to another. Sheet 1 contains the data I want to put into Sheet 2. Sheet 1, in short, contains a schedule for a person. I want to find in the log list of schedules in Sheet 2 the schedule for the...

Hi all, I have to say that I am quite new to excel. I create a function that returns a cell that contains a value starting at certain cell. The problem is that sometimes it find the correct cell others (for the same value) it doesn't. Here is my code: Public Function...

Hello All, I just took my first VBA course and brand new to the forum. I was hoping for some help in deleting duplicate values based off of multiple criterea. Each item has a unique Sec Code. I do not care about the "Group column." My desired results will show the security codes with all of...