excel 2007 macro

Greetings all... I have a subroutine that opens a 'data file' and moves the data from the current workbook to sheet 1 of the data file and then closes the data file. I have a similar routine that does the opposite. The idea is that I have a single file hidden from the users (read our sales...

I've got a data range across A:K, with headers in row 3 (all data entries beginning in row 4). I'm trying to run a macro which takes the prospect's name in A, and tells me which cells in C:K, if any, are blank for each producer's initials found in B. For example: If A4:K4 are all filled, it...

I've got a current macro which I'm using that works perfectly, at this point I'm just fine-tuning it (it's the same project from my previous thread). I'd like to add some code that organizes the spreadsheet based on column B, "Producer". The cells contain the initials of all my coworkers, and...

I have this macro here that is supposed to send emails to the people on column "C" and CC the people in column "F" and its supposed to attach a file located in my documents. The issue that I'm having is that it does not display the emails of each of the people on column "C" nor does it attach...

Please can I get some assistance on the following: 1. Look for duplicates rows throughout the different worksheets using the value under column A (excluding A1). 2. If there are duplicates, ensure that all the possible values combine are listed (excluding duplicate values but including...

I have an Excel 2007 spreadsheet that contains lab results that I want to import into Access. I need to reformat the data so that all the toxicology results are on a single row based on their LabNumber with only one row per lab number. My data looks like this: Excel 2007 <tbody> A B C D E...

Hello Forum: I am just getting started with macros, could not make this work, and would greatly appreciate your help and expertise. The task we are trying to execute is essentially populating a chart (Sheet 1) repeatedly with data from sequential rows in a table (Sheet 2), and saving each...

Hi After a couple of research I found a code that in theory works with an array of values that define the filter criteria to work with, when I tested as I download it it worked, however when I change those to the values I need, the filter result went blank, so this where I need the assistance I...

I use Excel 2007, and am the go-to person for most Excel questions in my department, but I've never had to write or execute a macro. I have a list of over 19,500 Member ID's that when imported into an excel sheet, drops the leading zero off of the number. There is no way to control how it is...

I am running troubeshooting a macro in EXCEL 2007 . The Dim statements appear as follows: Dim jbnme(17) As String, cpup(17) As Integer,'. I am familiar with the Dim variable declaration but what does the (17) represent? thanks, Bruce

I have imported a macro from a workbook into my personal.xlsb file so that I can run across different workbooks and activate via the Quick Access Toolbar (QAT). The macro uses data from a source worksheet (variable name) and copies/reformats it on a new target worksheet (in the same workbook)...

Hi, I was previously working in Excel 2000 and have upgraded to Excel 2007 only a couple of months ago. Background to problem: I have a workbook with 3 different sheets. I only want 1 of the sheets to be "Activated" at a particular time. So, for the sheet that I want to de-activate, I create...

I have 144 excel files in one folder, their name ranged from 001, 002, 003, .....156 (File names correspond to subject ID, some of the subjects are missing) I want to get partial data from each file and then paste into a new file to generate a table with three col. like below FileName (Name of...