Ability to define a cut and paste automatically

[Orencio]

Excel has a major drawback for me to be able to write a Macro which can
understand just how much of rwo data I want to define for a cut and paste
operation. I have specdific fields which contain the same data for up to 12
rows, then this data changes. My need is to only select those rows with the
same data contained in that specific field. then, do the cut/paste and loop
back to the initial document and only select the next set of specific field
data in a given number of rows, etc.
I assume this can be accomplished in a VBA module, but not by simply using a
Macro.
Lee

 

[Arvin Meyer]

You may want to select your data from a query, rather than a table.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Larry Daugherty]

There is no reference to MS Access in your post.

You may want to post Excel issues into one or more of the Excel
newsgroups.

HTH