Hello All,
Running into some problems with Excel. My understanding of Macros is quite basic, but can read code at a basic level.
This document is pulling information from multiple (10-15) schedules that contain all scheduling data for an event, and compiling just the Transport information. All current schedules are formatted the same, so the macro shouldn't need to change for each document.
What I'm trying to do is copy the contents from specific cells in a row, to a new workbook, only if a cell in column F contains "GT". And then re-arrange the order of the rows in the new workbook.
i.e. If Cell F24 contained "GT", then Copy C24(Date) to the next fully available row in A column in the new workbook, then copy D24(Start Time) to the same row that C24 went into, however this time in B column. Then copy E24(End Time) to the same row that C24 went into, however this time in C column.
And so on and so forth, until there is no more data to read in each file.
Any help that you could send my way would be greatly appreciated.
Thanks in advance,
Dan.
Running into some problems with Excel. My understanding of Macros is quite basic, but can read code at a basic level.
This document is pulling information from multiple (10-15) schedules that contain all scheduling data for an event, and compiling just the Transport information. All current schedules are formatted the same, so the macro shouldn't need to change for each document.
What I'm trying to do is copy the contents from specific cells in a row, to a new workbook, only if a cell in column F contains "GT". And then re-arrange the order of the rows in the new workbook.
i.e. If Cell F24 contained "GT", then Copy C24(Date) to the next fully available row in A column in the new workbook, then copy D24(Start Time) to the same row that C24 went into, however this time in B column. Then copy E24(End Time) to the same row that C24 went into, however this time in C column.
And so on and so forth, until there is no more data to read in each file.
Any help that you could send my way would be greatly appreciated.
Thanks in advance,
Dan.
