Hi everyone,
I'm looking for help creating an automated task with MS Excel.
Current I have a document that looks something like this...
ROW USER ID NAME POINTS
1 64 Jimmy 293
2 62 Thomas 32
3 66 Jarred 20
4 67 Bill 7
5 65 Ben 5
I would like to have an automated script or formula that would allow me to add rows for each users based on the numbers of points they have.
For an example let's take USER 65 (BEN)...
I would like to see the following:
ROW USER ID NAME POINTS
1 65 BEN 1
1 65 BEN 1
1 65 BEN 1
1 65 BEN 1
1 65 BEN 1
4 67 Bill 1
4 67 Bill 1
4 67 Bill 1
etc...
So it's adding the same value based on the number of points this user has.
Thanks everyone!
I am a 1st class degree holder in IT with 4 years experience in online projects including spread sheets. I am an excel expert and willing to do this for you. So please refer PM for more details. Thanks in advance!
Hi,
I have many years of experience developing macros in MS Excel.
It is possible to create a macro to add an amount of rows based on the points the user has.
Hi, i'm confident that I can deliver the project to the required specification. I assume there is a good reason for this extra row requirement & would happlily help you with further functionallity within the bid.