ExcelBanter - copy and paste if

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - copy and paste if (https://www.excelbanter.com/excel-discussion-misc-queries/257983-copy-paste-if.html)

Randy

copy and paste if

In column "A" I have my subtotals
I need to find subtotal "Jim" in column "A" of worksheet 1
xlToRight get subtotal amount copy and paste into a cell in worksheet 2
--
Randy

Randy

copy and paste if

Added note, I need to do this for each sales person so I need a macro
also note that the subtotal will never be in the same row each week

Thank you
--
Randy

"Randy" wrote:

In column "A" I have my subtotals
I need to find subtotal "Jim" in column "A" of worksheet 1
xlToRight get subtotal amount copy and paste into a cell in worksheet 2
--
Randy

All times are GMT +1. The time now is 12:05 AM.