excel 2010 & vba

Following on from another thread, I'm working on a report with two pivot tables where I need to have some way of comparing the data from the first pivot with the second one to see if it matches or not. If I was producing this analysis for myself I would normally just paste special values both...

Good Morning/Afternoon/Evening, I'm normally ok with VBA in Excel but i'm really struggling to understand what I have done wrong here. My end goal is to search for a file (using only the first part of the file name) in a set of folders and then send back to the calling function the full file...

Hello there. Good afternoon. I fairly new to VBA, I use it to work on simple macros to automate my time. I asked for help on Stack Overflow, but unfortunately, i could not get the answer I need. The code the friend provided didn't work. (Link) I am looking for an Excel macro which copies...

Hi I'm using Excel 2010. I need to send out emails with a subset of the data in an Excel file. Here is some helpful information about the data itself: The data is populated in columns A - T. Row 1 is a header row. Then there are nearly 300 rows of data. Column F contains the Transaction...

This is for Excel 2010. I have a workbook with the first tab "Master". I want to keep this tab for data entry but have separate tabs based on column G - "OwnerType" as the category, my first row is a header. I found a macro that looks like it might work for most of what I do but it does not...

I have found several fine examples of setting Conditional Formatting using VBA. What I would like to do is capture the existing rules settings (I'm looking at thousands of rows by 94 columns). Is this even possible? Any ideas

I have three sheets ( 1.GCBC 2.RHPOOLLVL 3.Comparison Summary) inside my excel file. My goal is to fill the sheet 3 ('comparison summary') from the values of sheets 1 & 2. following is the code i have written to achieve the results, this is working fine but taking hell lot of time to complete...

Hello, I had a working macro but today it started giving me an error. When formatting the data, it is deleting 2 columns when it is to be deleting 1. I am not sure why it is doing this. Any tips or suggestions would be greatly appreciated. Below is the section of code where it is doing this...

I have an Excel 2010 workbook where I combined mailing lists from three sources. Each line in the workbook contained an email address, a code indicating the original source list and other information associated with the address. <tbody> Code Address Fld 1 Fld 2 Fld3 R abc@gmail.com x X L...

Hello, I created a macro to open up a file location, move to the search box, paste text that was entered through an input box, then select the file and open it (a pdf). I am having issues where it doesn't actually enter the Windows Explorer when it opens it and ends up pasting the MO text in...

Hi, I have just recorded the below macro to go through and select each account number on a pivot table filter. I was just wondering if anyone knew any code that would do the below for all values in the filter instead of me going through and recording it ac number by account number? the...

Hi I'm trying to write a VBA code in Excel that opens a folder (this folder will only contain Zip files) and from the zip archive open a xlsm file with same name as zip file, run some macros that are inside the xlsm file. Then save it as a xlsx file (removing the macros in the file) and saving...