Akshay Salvi
New Member
Hi Excel Gurus,
Need you help in creating a macro to copy data from a vertical format and updating it in horizontal format. formats uploaded.
I have copied 2 data field from Vertical to Horizontal for example, Manually .
Following is wht i am trying to make a macro do, data from Agent name to Actual time ( in Vertical file ) should be pasted in Rows C to M ( in horizontal file), data from fields Emulate to Tag in QMX should be pasted from rows N to AO with their respective start and stop times. Then it should move to next set of data and repete above steps.
I have clsoe to 10 files with data in Vertical format, Which is a painful task to convert manually.
Any help would be appreciated
Need you help in creating a macro to copy data from a vertical format and updating it in horizontal format. formats uploaded.
I have copied 2 data field from Vertical to Horizontal for example, Manually .
Following is wht i am trying to make a macro do, data from Agent name to Actual time ( in Vertical file ) should be pasted in Rows C to M ( in horizontal file), data from fields Emulate to Tag in QMX should be pasted from rows N to AO with their respective start and stop times. Then it should move to next set of data and repete above steps.
I have clsoe to 10 files with data in Vertical format, Which is a painful task to convert manually.
Any help would be appreciated