copy and paste problem

[newbie1983]

anyone know how to copy specific cells and paste into another sheet performing a count? without the traditional cut n paste method, preferably using activecell but any solution will do cheers

i.e

from sheet 1:

HW0354
HW0354
HW0354
HW0354
HW0354
HW0438
HW0438

to sheet 2:
HWO354 = 5
HWO438 = 2

 

[SkipVought]

Hi,

You don't have to copy 'n' paste to get a VALUE for one range to another.

AND you don't have to, nor is it a good idea, to Activate and Select the objects that you want to work on. (see my FAQ - faq707-4105)

Something like this works...

Sheet2.Cells(1,1).value = Sheet1.Cells(1,1).value

is, for values, equivalent to copying the value in Sheet1!A1 and pasting it in Sheet2!A1.

What are you actually trying to do?


Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[xlbo]

why not whack a pivot table on the data
use the field as the row and COUNT of field as the value

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[SkipVought]

How perceptive, Geoff!

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[xlbo]

why thank you Watson

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[newbie1983]

Geoff,
use the field as the row and COUNT of field as the value
what do u mean by this?

kind regards
Hinesh

 

[xlbo]

Select your data
go Data>Pivottable

go thru the wizard until you can see a "Layout" button
Click on this
You should have one field only in the pivottable - lets say the header is "myField"

Drag "myField" from the list on the right into the ROW section of the layout page
Drag "myField" (again from the list on the right) into the VALUE area and if it does not say count (which it should), double click it in the value area and choose count from the options

finish going thru the wizard and see if it does what you want.....

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244