Modify existing macro to include decimal and stop manual edit of macro

Two things (sure one is quicker than the other):
1. using macro below to sort and transcribe data from an acquisition log. Data is input as a string (e.g. 1244) in one column, and I'd like to automatically have a decimal put in each value as it sorts and transcribes, so that the final value in the "Target" worksheet is 124.4.
2. when the acquisition system is adjusted, the acquisition log changes slightly (order of the tags in a column for a specific time). I manually have to edit the macro with the first tag of the data set, last tag of the data set, and the number of total tags minus one. Is there a way to automatically have the macro know, based on the time, the first tag, last tag, and # of total tags without the manual edit? You can see in the attached workbook that not all of the transcriptions worked because the total tag # changed during acquisition...
test1.xlsm

Thanks!

Please Login or Register  to view this content.

1.as far as converting the string value of 1244 into a decimal of 124.4 then =((Value(A1))/10) will first convert the string in A1 to a value and then divide it by 10 to input the decimal.

2. Apologies, Im not sure what you mean in your second question, can you highlight the bits the manually amend and where you get the answers from?

1. I have roughly 30 data points, so I'm hoping that I don't need to make 30 additional columns (after the data has been sorted and organized) to place a decimal using a formula. I was hoping to be able to insert the decimal by using an addition to my existing macro.

2. Can do! I receive the acquisition data as shown in the workbook, sheet "Original Log." I manually count the number of entry for a specific time period, e.g. for 10/30/14 17:00, there are 62 entries/values. I also have to take note of the first entry and last entry for that time stamp, e.g. EDR P4 (psi) [first entry] and EDR P4 (psi)_RD [last entry]. I manually edit the macro in the bolded, underlined places below... I have to manually type in the first and last entry titles in the first bolded area and the total number of values/tags in 3 places after that. I was hoping that there was a way so that I didn't have to manually edit the macro if the first and last entry tags changed or if the number of tags changed. Right now, every time the first and last entry tag changes or if the number of tags change, I have to manually edit the macro, and it only sorts/organizes the rows that fit that exact criteria.

Please Login or Register  to view this content.