Help with Sorting

[Abdul Rahman]

Hi, need to sort data from several sheet to individual activity sheet

Thank you

[AliGW]

Using Excel 2013?

[Abdul Rahman]

Hi AliGW,

Im using Excel 2019

Thank you

[alansidman]

Please update your Profile to reflect the current version you are using.

[Abdul Rahman]

Done, Thank you very much for reminding me

[BadlySpelledBuoy]

One way would be to use VBA.

In the attached version of your file I've added the code shown below and a button on the first sheet to run it when clicked.

Worth noting, this is all based on guesswork as there wasn't a whole heap of information in your original post about what your desired outcome actually is.

Please Login or Register  to view this content.

For some reason it's not adding one of the names as I'd expect it to, but I need to go and cook dinner so can't look into the reason for that right now.

If this is any use to you I will come back and find why the one name isn't quite working then will update the code.

BSB

[BadlySpelledBuoy]

Found the issue mentioned above. It's a formatting thing. Need to change the font colour and style in B6 on the Badminton sheet to match the cell above.

BSB

[Abdul Rahman]

Thank q very much. That was the data I needed

Anyhow I need to add some more sheet as I cant upload more than 1,000kb data so do I have to add some code Set ws = Sheet4 Call MoveData and so on

and for the result, can the number run normally from 1 onwards

Thank you very much for the help

Njy your dinner then

[BadlySpelledBuoy]

do I have to add some code Set ws = Sheet4 Call MoveData

Yes you can simply add more lines to that section. Just make sure the sheet number matches the codename of each one.
If your workbook was set up with all the class sheets at the start and no hidden sheets in between, the code could be adapted to loop through those rather than need to specify them in code. I was going to do that in the example file, but noticed some hidden sheets.
You could also loop through the sheets and only process any where the tab name starts in "Year" for example. That way you wouldn't have to add anything to the code and it wouldn't matter which order the sheets were in.
As I said, I was working from pure guesses as not much info provided.

and for the result, can the number run normally from 1 onwards

I'm not sure what you mean by this. Could you elaborate?

BSB

[Abdul Rahman]

Badminton (Physical)

No Nama Murid (Student Name) Year

1 MOHAMMAD Year 4A (2024)
2 MUHAMMAD Year 4A (2024)
3 MOHAMAD Year 4A (2024)
4 NUR H Year 4A (2024)
5 MUHAMMAD Year 4A (2024)
6 MD I Year 4A (2024)
7 ASYMAWI Year 5A (2024)
8 MOHAMMAD Year 5A (2024)

The No run normally and so on

[BadlySpelledBuoy]

So you want the numbers to just start at 1 and increment, rather than use the numbers from the class sheets?

BSB

[Abdul Rahman]

Yes Sir/Madam, Thank you

[BadlySpelledBuoy]

Try this slightly amended version.

Please Login or Register  to view this content.

Note I also moved the line for the pop up message box so it only appears once. I'd put it in completely the wrong place before because I added it after I'd tested it.

BSB

[Abdul Rahman]

Yes Sir/Madam, that was amazing, help me a lot.

Thank you very much.

I will continue my work tomorrow, need to rest now, its nearly 4 am my time.

I will come back to you if there is any updates.

Anyway good night and sleep tide Sir/Madam.

[BadlySpelledBuoy]

Glad I could help.

Enjoy your sleep.

I shall check back tomorrow to see if there's further help required.

BSB

[Abdul Rahman]

Hi Sir/Madam Gd Evening

Hows your day

I just noticed that there are so many hidden sheets. I just helping my wife finishing their school task so I had deleted all unnecessary sheets

Task is almost finish, just wanted to add some command to clear data if maybe they want to add some more data.

Thank you very much for your help

[Abdul Rahman]

Hi Sir/Madam.

I was just notice that the result of the data n the Year row only come out with Year*A no B or C

how would I add some code to VBA?

Thank you

[AliGW]

This is marked as SOLVED ...

[Abdul Rahman]

I post yesterday for some answer but no reply so I try to finish it.

I made it so I marked as SOLVED

but today I realised that there are some miss check on my side

Im sorry for the inconvenience caused

So how do I do now? to repost back

Thank you

[AliGW]

Just remove the SOLVED tag for now if you want extra assistance.

[Abdul Rahman]

just click Mark this thread as unsolved

[Abdul Rahman]

Done. Thank you Madam