Still learning

Closed
8AJB8 Posts 1 Registration date Thursday 10 April 2014 Status Member Last seen 11 April 2014 - 10 Apr 2014 à 20:35
 Blocked Profile - 10 Apr 2014 à 20:38
I have an excel invoice made up with guest details.
I need to place information into another spread sheet, this gets rather tedious to do every day, there has to be a simpler way of doing it.

At the moment I have hyperlinked the Invoice into one column of the spread sheet
My objective is to autofil the information from the hyperlinked invoice to the spread sheet.

Please help
Arthur

1 response

Blocked Profile
10 Apr 2014 à 20:38
Ok, become familier with DDE, Dynamic Date Exchange. That way you can link to a file that you have been presented with, because that "department" wishes to make it that way!

Can you ask that other creator of the report to format it in another way? Communication is the key!