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.
Bookmarks