View Single Post
  #2   Report Post  
bala_vb bala_vb is offline
Senior Member
 
Location: Hyderabad
Posts: 237
Thumbs up

Quote:
Originally Posted by Tromal View Post
I have colum A and B. I use SUMPRODUCT to calculate the sum of values in
column B with a criteria.

What I would like to do is copy the cells from column A (some row that
SUMPRODUCT have use) and paste them elsewhere.
if you are looking to copy and paste the values.

copy the values, go to cells where you to paste, right click and choose "paste special values".

all the best
__________________
Thanks
Bala