View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
glensfallslady glensfallslady is offline
external usenet poster
 
Posts: 9
Default Move Specific Text to new worksheet

I have 2 worksheets in the same workbook, "Sheet 1" and "Sheet 2". From Sheet
2, I need to pull the count from Col H where Col A states, "Account
Employees" and place that number in Cell B12 on Sheet 1. Then I want to copy
the count from Col H where Col A states, "Accounting Exempt" and copy that
count to Cell B13 on Sheet 1. I have about 100 of these counts I need to
copy each day so I'd like to automate it with a macro. Can anybody help me
get started with this, thanks