ok i'm going to try to describe what i want to do accurately here.

I'm looking for a way to search a column for a specified value and when it
finds that value, which appears multiple times, I want to copy that entire
row into another sheet in a specified area. I need to be able to do this for
mulitiple different values that each appear multiple times in the column. How
do i do that?

In case that makes no sense i'm going to put it another way. I have 56
accounts on a commission report. Each account has a unique customer ID. The
report shows every time they ordered last month, so the same account will
show up many times. I have 5 salespeople. I want to make it so that when i
get a new report i can simply copy it into the referenced sheet (call it
sheet2) and have the sales for that month automatically sort on the sheet
with all my salespeoples names on it (call it sheet1). what do i have to do
to get excel to search column D for C12345 then when it finds it copy the
whole row where it found C12345 (<-- actual format of our customer ID) to
sheet1 in the area i specify.

I hope that this is doable.

Have you tried using a pivot table?
If that won't do what you want, you'll probably need a macro to do the
repeated cut and paste operation you described.

--
HTH

JonR

Please rate your posts


"Tbar" wrote:

ok i'm going to try to describe what i want to do accurately here.

I'm looking for a way to search a column for a specified value and when it
finds that value, which appears multiple times, I want to copy that entire
row into another sheet in a specified area. I need to be able to do this for
mulitiple different values that each appear multiple times in the column. How
do i do that?

In case that makes no sense i'm going to put it another way. I have 56
accounts on a commission report. Each account has a unique customer ID. The
report shows every time they ordered last month, so the same account will
show up many times. I have 5 salespeople. I want to make it so that when i
get a new report i can simply copy it into the referenced sheet (call it
sheet2) and have the sales for that month automatically sort on the sheet
with all my salespeoples names on it (call it sheet1). what do i have to do
to get excel to search column D for C12345 then when it finds it copy the
whole row where it found C12345 (<-- actual format of our customer ID) to
sheet1 in the area i specify.

I hope that this is doable.

I've not gotten that familiar with excel yet. I haven't figured out how to do
pivot tables or macros yet.

"JonR" wrote:

Have you tried using a pivot table?
If that won't do what you want, you'll probably need a macro to do the
repeated cut and paste operation you described.

--
HTH

JonR

Please rate your posts


"Tbar" wrote:

ok i'm going to try to describe what i want to do accurately here.

I'm looking for a way to search a column for a specified value and when it
finds that value, which appears multiple times, I want to copy that entire
row into another sheet in a specified area. I need to be able to do this for
mulitiple different values that each appear multiple times in the column. How
do i do that?

In case that makes no sense i'm going to put it another way. I have 56
accounts on a commission report. Each account has a unique customer ID. The
report shows every time they ordered last month, so the same account will
show up many times. I have 5 salespeople. I want to make it so that when i
get a new report i can simply copy it into the referenced sheet (call it
sheet2) and have the sales for that month automatically sort on the sheet
with all my salespeoples names on it (call it sheet1). what do i have to do
to get excel to search column D for C12345 then when it finds it copy the
whole row where it found C12345 (<-- actual format of our customer ID) to
sheet1 in the area i specify.

I hope that this is doable.

In your drop downs on the top row, go to Data- Pivot Table and Pivot Chart
Report

Clicking on that will open a wizard that will walk you through the process.
From your description, you want your salespeople as the row fields, dates as
column headers, and total sales would be your data items.

Let me know if it works for you
--
HTH

JonR

Please rate your posts


"Tbar" wrote:

I've not gotten that familiar with excel yet. I haven't figured out how to do
pivot tables or macros yet.

"JonR" wrote:

Have you tried using a pivot table?
If that won't do what you want, you'll probably need a macro to do the
repeated cut and paste operation you described.

--
HTH

JonR

Please rate your posts


"Tbar" wrote:

ok i'm going to try to describe what i want to do accurately here.

I'm looking for a way to search a column for a specified value and when it
finds that value, which appears multiple times, I want to copy that entire
row into another sheet in a specified area. I need to be able to do this for
mulitiple different values that each appear multiple times in the column. How
do i do that?

In case that makes no sense i'm going to put it another way. I have 56
accounts on a commission report. Each account has a unique customer ID. The
report shows every time they ordered last month, so the same account will
show up many times. I have 5 salespeople. I want to make it so that when i
get a new report i can simply copy it into the referenced sheet (call it
sheet2) and have the sales for that month automatically sort on the sheet
with all my salespeoples names on it (call it sheet1). what do i have to do
to get excel to search column D for C12345 then when it finds it copy the
whole row where it found C12345 (<-- actual format of our customer ID) to
sheet1 in the area i specify.

I hope that this is doable.