How do I insert cells at every change of data in column A

S

shrek

Board Regular
Joined
Dec 16, 2005
Messages
244
If I explain what I need done it may be easier.
What is it at each change in column A I need the cells in the row above in columns F and G moving down one cell and then the row that F and G have been moved to I need that moving down one cell too.

I.E if Data changed at A10 I need the data in F9 and G9 moved down to F10 and G10 and then data in A-E10 moved down to A11-E11.

Can anyone help.I also need this to repeat all the way down the workbook where there is a change of data in column A. It will always start LTP BY its just the numbers will increase if that makes any difference.

Hope this makes sense.

Many Thanks
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Sort by date Sort by votes
Just to explain better.
This is how it looks at present.
WORKBOOK FOR SORTING DIAGS.xls
ABCDEFG
10LTPBY2352Euston12.5213.092N23
11LTPBY2352Bletchley14.096.54
12LTPBY2353Euston8.249.092N05
13LTPBY2353Nhampton10.3910.532N10
Sheet1


And as shown in this one the difference in rows 11-15.
WORKBOOK FOR SORTING DIAGS.xls
ABCDEFGH
9LTPBY2352Bletchley10.4311.442N12
10LTPBY2352Euston12.5213.092N23
11LTPBY2352Bletchley14.09
126.54
13LTPBY2353Euston8.249.092N05
14LTPBY2353Nhampton10.3910.532N10
15LTPBY2353Bletchley11.1212.142N14
Sheet1


This is how I would need them to be.
 
Upvote 0
shrek/tweacle

You are cross posting all over the place and using various names too.

This is not good forum etiquette and it's probably reducing your chances of anybody responding to your posts.

As for a solution to this latest post, I don't quite see the logic behind the results.

There's actually data in the result that doesn't appear in the original data.:eek:
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
Excel chart with a line that will adjust certain cells
Replies
0
Views
88
jondavis1987
J
U
  • Solved
Transfer data but not rows with a certain blank cell
Replies
2
Views
260
UTB
U
J
  • Question
Complex Move data from two spreadsheets with similar data in different columns to a specific column in an existing spreadsheet(Sheet 3)
Replies
0
Views
133
JMC57
J
theYaniac
  • Solved
I would like to insert a blank row between each new unique identifier in column A.
Replies
3
Views
202
MARK858
MARK858
K
  • Question
Looking to find the correct formulas / Open to Ideas
Replies
2
Views
267
KRice
K

Forum statistics

Threads
1,215,232
Messages
6,123,765
Members
449,120
Latest member
Aa2

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top