Need Help on Macro in Excel 2010

[AnilS]

Hi,

I have a set of data on a spreadsheet.
The Column "A" contains Serial Nos. 1 to 5000.
The Column "AT" contains the actual data and it extends upto 10 columns or so say till Columns "BC".
The data is upto several rows around 3000 rows. Each of these rows contain data from Column "AT" to Columns "BC". Each of these rows contain the first cell value in the multiples of 10 (like ex: 10, 20,30,40 60,90..etc).

What is required:
We know that the Column "A" has Sl Nos. from 1 to 5000, and if the cell "A25" has the SL No. as "30", then the actual data which is present in columns "AT" to "BC" should accordingly to move the respective row.

i.e. whichever the row has the matching number (30) in the column "AT", that entire set of data should move to the Row No. 25.

Let me know if anyone has a Macros for this.

- @NL

 

[Smitty]

Welcome to the Board!

I think you're going to need to be a bit more concise. It would help if you post a shot of what you've got now (see the HTML Maker link in my sig).

 

[AnilS]

Welcome to the Board!

I think you're going to need to be a bit more concise. It would help if you post a shot of what you've got now (see the HTML Maker link in my sig).

Thanks for the reply Smitty.

The below link contains the image for the same.

https://docs.google.com/file/d/0B0X_I7fFzmbpbnktWmhBM3ZSQ1k/edit

 

[AnilS]

Thanks for the reply Smitty.

The below link contains the image for the same.

https://docs.google.com/file/d/0B0X_I7fFzmbpbnktWmhBM3ZSQ1k/edit

Now seeing the image,
the data which is available in "AT44" to "AY44" should be moved to "AT53" to "AY53".

Hope this helps.

 

[Smitty]

Unfortunately, I can't access filesharing sites, so maybe someone else will be able to pitch in. If you can post some screen shots it would be better.

 

[shorn]

Smitty,

Heres a basic idea of what his picture looks like.

	a	b	c	d	e	f	g	h
1	10
2	20
3	30			30	data	data	data	data
4	40			40	data	data	data	data
5	50
6	60
7	70			50	data	data	data	data
8	80			10	data	data	data	data

<tbody>
</tbody>

The idea being that he wants the data in d1:h8 to sort itself by rows based on the data in a1:a8. So d3 matches a3..d4 a4..etc.. d7 should sort up to d5 and d8 should sort up to d1.

So my first idea is if you had the base data in another sheet or a data base you could display it here using something with an Hlookup. Essentially Hlook up in say d1, e1, f1, g1, h1. It would access the data table on the other sheet and then display whatever was in the a row. This would mean you would have to copy the code down for all the lines but would allow you the ability to instantly change anything in a1

Past that you could use something like this..http://excelexperts.com/sorting-custom-sort-order-vba..only problem here is that the sort stops working if you have blanks and does not up the information into the same row.

 

[AnilS]

Smitty,

Heres a basic idea of what his picture looks like.

	a	b	c	d	e	f	g	h
1	10
2	20
3	30			30	data	data	data	data
4	40			40	data	data	data	data
5	50
6	60
7	70			50	data	data	data	data
8	80			10	data	data	data	data

<tbody>
</tbody>

The idea being that he wants the data in d1:h8 to sort itself by rows based on the data in a1:a8. So d3 matches a3..d4 a4..etc.. d7 should sort up to d5 and d8 should sort up to d1.

So my first idea is if you had the base data in another sheet or a data base you could display it here using something with an Hlookup. Essentially Hlook up in say d1, e1, f1, g1, h1. It would access the data table on the other sheet and then display whatever was in the a row. This would mean you would have to copy the code down for all the lines but would allow you the ability to instantly change anything in a1

Past that you could use something like this..http://excelexperts.com/sorting-custom-sort-order-vba..only problem here is that the sort stops working if you have blanks and does not up the information into the same row.

Hi Shorn,

Thanks for the reply.

Just would like to mention that all the data will be available in the same sheet and also there would be no spaces in the middle as given in the pic.


Please let me know if you have a code or so for the same.

-@NL

 

[Smitty]

I'm not suite sure how you would approach this. Cutting/Pasting would seem logical, however you also have to take into account if a row already has existing data in it that doesn't belong and move that.

Unfortunately the data setup doesn't make much sense to me, but if I have some time this afternoon I'll see what I can do.

 

[AnilS]

I'm not suite sure how you would approach this. Cutting/Pasting would seem logical, however you also have to take into account if a row already has existing data in it that doesn't belong and move that.

Unfortunately the data setup doesn't make much sense to me, but if I have some time this afternoon I'll see what I can do.

Sure Smitty,

Will wait for your ideas.

- @NL

 

[jsotola]

one way,

sort column A in ascending order

sort columns D:H in ascending order on column D

first row in D:H, if A <> D then insert blank cells above D:H until A=D

go down one row in D:H and repeat