A challenging digit by digit manipulation, rotate the digit in range of 0 to 9

laucn · #6 05-16-2015, 11:39 PM

Quote:

Originally Posted by excelledsoftware

Glad it worked. As for the additional add on I would be happy to help. I need to clarify a little further though.
Right now your data is set up to have a data row and then the manipulation rows below. If you want to add the row titles (Manipulation 1, Manipulation 2 etc.) Then I need to know how exactly you would want it to happen. Do you want to put in the data and then click a button that automatically fills in the manipulations based off of how many spaces there are between the data rows? Can you post a sample workbook with one worksheet that has the data you want to enter and then another worksheet that has the result of what you are looking for.

Hi, thanks for your quick response, i didn't expect this as i believe its now midnight at your area.

My data were imported from a text file.
The original piece of data looks like this:

On the earlier example, the rows of "Manipulation 1" and “Manipulation 2" were added with manual effort.
After execute the codes, i would like the Manipulation row to be added, and the calculation result to be populated respectively.
And outcome should looks like this, assuming i would like to add only two manipulation rows.

A button is not necessary, hit F5 execute the codes is good enough.

And many thanks again ^^

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook export to a calendar csv file is transposing single digit starting dates	sala-marie	Excel	3	10-27-2013 09:32 PM
Recipient counter in Mail Merge Wizard displays only one digit in Word	Liuneddu	Word	1	08-13-2013 03:57 AM
Import contact from EXCEL to Outlook (no zero in left side digit)	nmo111	Outlook	1	05-28-2010 11:00 AM
Dividing merge cell into ten equal rectangles for inputing Digit?	aligahk06	Excel	0	05-12-2010 06:56 AM
in WORD, how do i type a 9-digit phone number "xxxxxxxxx" and have it automatically..	jay8962	Word	0	04-08-2010 11:08 AM