copy column of hyperlinks to a row

sleekgeek

New Member
Joined
Sep 27, 2010
Messages
34
Hi all, Im trying to create a fully automated document tracking index.
I have 2 sheets

Sheet 1 (Items in columns A, C, D are hyperlinked to pdf files):
File NameDateDrawing NumberRev
025510-011_D.pdf2/5/2011025510-011A
025510-100_A.pdf17/11/2011025510-100A
025510-100_B.pdf18/11/2011025510-100B

<tbody>
</tbody>







Sheet 2:
Drawing NumberRevRev
02510-011A
02510-100AB

<tbody>
</tbody>







I have got the items in column A (no hyperlinks req'd), but I cant get the Rev columns to come over with hyperlinks.
The Rev columns in sheet 2 may contain letters and numbers and continue indefinitely.
I have exhausted my knowledge in vba I think, and Im going to need some help.
Thanks in advance
Sleekgeek
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

sleekgeek

New Member
Joined
Sep 27, 2010
Messages
34
Ive looked at pivot tables, but can't get the hyperlinks to copy.
Still looking for some suggestions.
 

sleekgeek

New Member
Joined
Sep 27, 2010
Messages
34
Ok, im slowly getting somewhere. What ive managed to do is to get my rev column to sort with alphabet before numbers, using a macro.

Now, my next idea is to transfer (copy) my rev column to a row, but "rotate" the items from the top of where the rev string starts. as below

initial revs in column
COL.A COL.B
drg1 A
drg1 B
drg1 C
drg1 0
drg1 1
drg1 2
drg2 A
drg2 B
drg2 C
drg2 0
drg2 1
drg2 2

-----------
new revs in rows
COL.A COL.B--->
drg1 A B C 0 1 2
drg1
drg1
drg1
drg1
drg1
drg2 A B C 0 1 2
drg2
drg2
drg2
drg2
drg2

I hope somebody can help.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,493
Messages
5,601,998
Members
414,490
Latest member
Rip181

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top