bobbyj1234
New Member
- Joined
- Sep 16, 2015
- Messages
- 1
Hi,
I am new to this Forum and very new to using VBA in excel, so please excuse my lack of proper vocabulary or knowledge.
I am a film editor and we have EDLs that show us all of the cuts in a film with time codes in and out - an excel workbook of the movie. We have a separate document called an ALE, which shows all of the info for each clip - without the time codes in and out. More of an excel key. When an EDL is created we are limited to an 8 character identifier, therefore we create 6-8 character codes to represent clips. These clips are used in multiple locations and can be present in the worksheet in 20 - 30 different rows if the clip is used multiple times in the film:
<tbody>
</tbody>In addition to the clip name, there are 17 columns of data in the ALE. Is there any way to copy the 17 columns of data while replacing the clip identifier?
I am open to having 2 different VBA as well. I would assume that this is very similar to a VLookup but I am looking for something a little more automated. Any help is much appreciated. And once again, excuse my lack of knowledge on this subject, and happy to try to explain in more detail.
Thanks,
Bobby J
I am new to this Forum and very new to using VBA in excel, so please excuse my lack of proper vocabulary or knowledge.
I am a film editor and we have EDLs that show us all of the cuts in a film with time codes in and out - an excel workbook of the movie. We have a separate document called an ALE, which shows all of the info for each clip - without the time codes in and out. More of an excel key. When an EDL is created we are limited to an 8 character identifier, therefore we create 6-8 character codes to represent clips. These clips are used in multiple locations and can be present in the worksheet in 20 - 30 different rows if the clip is used multiple times in the film:
ES_2232M | ||||||
ES_2235M | ||||||
ES_2240M | ||||||
ES_2309 | ||||||
ES_2241 | ||||||
ES_2034 These codes then need to be replaced by the clip's full name:
<tbody> </tbody> |
<tbody>
</tbody>
I am open to having 2 different VBA as well. I would assume that this is very similar to a VLookup but I am looking for something a little more automated. Any help is much appreciated. And once again, excuse my lack of knowledge on this subject, and happy to try to explain in more detail.
Thanks,
Bobby J