marco

I need a pointer which code to use for pulling select data from a file. The file contains a lot of data that I do not need. I am currently dropping it into excel and then doing a text to columns to separate out what I need and would like to figure out a way to do it faster.

I have a spread sheet with 31 worksheets on it (30 baseball teams, and the 1 to simulate baseball games). I think I have the steps down that I need, but I just have no idea how to turn them into VB code for a Macro What I'd like it to do is the following (this is just the first half, of...

Hi! I am looking for some help creating a macro... I have a file with data in col A-L. The data in col L is a list of names. I'd like to create a seperate worksheet, maybe even a seperate file, for each name. On the new file I'd like to pull over all the data from col A-M (or A-L) for each row...

I'm looking for help to create a marco that will auto update a workbook, "Master.xlsx" upon opening from another workbook, "Test.xlsx". Is there VB code that will automatically update when opening "Master"? The thing is that "Test" workbook will have rows added in between the existing rows...

Hi everyone, I tried to use the Math.Round function inside my UDF Add-In so that it would return a result rounded of to 2 decimal places. Also, I have this "test table" wherein I could compare the 1.) Results From Manual (left blue column) from 2.) Results From UDF (right blue column)...

Hi everyone, I'm a newbie in using Excel and VBA. I've made this VBAProject that uses a UserForm. The program accepts user inputs from the TextBoxes which are processed then displays the output unto another TextBox. Now I'm planning to improve the functionality of my current VBAProject by...

I need to send out a holiday email to our clients and have all their data in excel. Simple enough, but I need to create a field/column that shows who in my company the email is from taking into account that in most cases each contact needs to have more than one person appearing in the “from”...

I have a column that has different SIC codes in it (00045, 00046, etc). I would like to set up a macro or filter that would take cells in this column and delete each row that contains a certain code that I don't want. Example, I want to delete all the rows with SIC codes that have 00345...

Hi is there any marco to compare column A data with column B data . if Column A data does not appear in column B then 1) that data should be displayed in column C 2) and if present should be displayed as "OK" Ex : Column A Column B Column C...

Hi, I am trying to go through 5000 odd rows to check if a debit and a credit for the same value exist in column E. Basically, what i need is a macro to check the reference number in column B and delete rows that have the matching debit and a credit for that reference number e:g <TABLE...

Hello Excel Gurus! Hopefully I can explain my dilemma, a bit of background: it's a supplier score monthly tracker, very basic, list of suppliers in column A then Jan scores in column B, Feb scores in column C etc etc. I've been working on Macros for arranging by score based on the last...