Hi,

Current Period which is text goes in Column H. The 1-4 numbers which are in
columns J to M.

"Quarter to Date" on the line below is also text with its own corresponding
data in columns J to M.

Once complete the "Quarter to Date" should be next to the consultant on
thesame line

Hope it makes sense ..
"Don Guillett" wrote:


I'm a bit confused about what goes where. How about a couple of examples of
AFTER.
You can use a findnext macro to locate the text along with a CUT procedure
and a row.delete
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"manfareed" wrote in message
...
Hi,
I need a macro to delete part of a row eg. column H to Column M and in its
place copy data into these columns from the row directly below it. Once
done
the row below should be "deleted". [please see below]
The Data is arranged as follows :

Cash Received

Consultant 1 Current Period 1 2 3 4
Quarter To Date 1 2 3 4

Consultant 2 Current Period 1 2 3 4
Quarter To Date 1 2 3 4
And so on ...

I would need to delete from "Current Period" in Column H to Column M in
all
rows which have "Current Period"
In its place I would need to copy "Quarter To Date" from the line below
plus
data in Columns J to M.

Once Done the line with originally with "Quarter to Date" needs to be
deleted so that everything moves up 1 row.