Resize/Create a New Partition in GParted

Question

We have a workbook of two sheets: Sheet1 and Sheet2. In Sheet1, there's only one column that contains data of nearly 1 million cells (names of products). Sheet2 has existing data (also names of products) where the first row is reserved for the alphabetic column headers; A-Z and NUM (27 cols). What we're after is a macro that will sort data in Sheet1 a-z0-9, and then distribute (move) each letter's chunk of data from Sheet1 to the bottom of data of each designated column of the letter in Sheet2. We have actually searched for similar solutions in many forums that we can adopt and adapt, but we basically did not find any.Can anyone help us please? Thanks in advance.

Solution

You can not resize a partition when it is in use. Boot a live CD, make sure the partition is not mounted, and run gparted from there.

Make sure the swap partition is not mounted either (swapoff).

You can mount / unmount a partition from gparted as well.

Comments

[Our Man in Bananas]

please show us the code you have written, or started to write, and we'll help you fix it or improve it...

[terry]

Thank you Philip for your promptness, but actually we don't have any code that we can build upon.

[Our Man in Bananas]

we don't write code, we help developers improve code or fix error or problems

[terry]

No worries, I will do my homework to find similar code, which we can build upon. as soon as I get it I will post it here. thank Philip, I'm actually still learning how to use StackOverflow.

[Charlie]

so I unmount it before I boot off the live cd?

[Panther]

No, just boot a live CD and unmount sway or your hard drive if they were automatically mounted (ubuntu tends to mount any swap partitions it finds). The gparted live CD is a nice tool as it is a smaller download and does not auto mount partitions.

[terry]

I really don't know what to say as thanking is not enough Enhzflep. You saved days for me by posting this script; thank you very very much. I will run it and feed you back. All the best.

[enhzflep]

No worries. :-) Consider it said. Its just experience, hope it helps you to gather a little more.

[terry]

Well, I created random strings and manually sorted them in Sheet1.ColumnA, and as I ran sub tmp(), I got a "Compile error: Duplicate declaration in current scope" highlighting "StartLetter" variable defined in Function findFirstItemStartingWith(startLetter) As Integer in second line. Any suggestions?

[enhzflep]

Ahh. oops, sorry. Just remove the variable (or rename it) I was going to use it to make a function that would find the first & last row of entries beginning with the same letter. Keep the one in the function signature though, that one is used. I'll update the code in a second.