Copy records with the same value in a column to a new sheet or workbook

Hi All,

I have a requirement to create some Excel macros. To be honest, I am not a programmer but I have done some programming in C# 4 years ago for about a year. So i am hoping that if someone can give me the code of the sample I provide, I should be able to build on it.

The scenario is like this:

Master file has the following info:

Item Code    Jan 07     FEB 07
AB123         $20.00     $2018.00
AB123         $30.00     $209.00     
CD456         $40.00     $780.00
CD456         $50.00     $2000.00

I need to do the following:
1. Create a button in the master file which when clicked creates a new excel file with the name "TestData" and creates a new worksheet for each Item Code.
2. In each sheet, it will create a table with the Sale column for each year.
3. In the "TestData" file, another button is required so that if the user modifies some data, e.g., Price, then this updated information can be updated back into the Master file.

I have used a very basic version of my requirement. I will greatly appreciate your assistance in this regards.

Regards,
Reeya

Please read forum rules below. I've amended your title for you.

This link may get you started

http://www.rondebruin.nl/copy5.htm

VBA Noob

You don't seem to have a year column, just months.