Move Cell Data based on column data

[bigroo1958]

Hi All,

Here's what I wish to to do with this spreadsheet which has over 25,000 rows of data.

Sheet1 has the sample data.
If column A has the callsign repeated over a few rows, then look over to column E and find "Nighttime" if it's present.
I want to then move on the same row that has "Nighttime" the data under column "Daytime" up one row to sit under "Night Power" and then delete the whole row which has "Nighttime" in column E.

So in my example column A Call KRXA is repeated twice. Look on the second row and fild "Nighttime" under column E, I then want the value 0.5 under column L moved up one row and across one column to the right under Night Power, then delete the second row.

I hope this makes sense, sheet 2 has an example of what I want.

Thanks.

[JBeaucaire]

Assuming as your sample sheet indicates there are always 2 rows of data for each call sign entry, perhaps this will work...trying simple first.

Please Login or Register  to view this content.

If your data includes multiple instances of the same call sign, this won't work. A fuller example would be helpful.

[bigroo1958]

JBeaucaire,

Thanks for the quick response.
Your code did exactly what I wanted, I appreciate the help and assistance!!

Thanks