VLookup

J

Jennifer

I'm currently editing an excel file for my boss where I'm inserting a bunch
of VLookup functions in order for data to be automatically entered. However,
the file from which I'm getting the data is most likely in a different spot
on my computer than it is on my boss'.

Will there be a way that I can change ALL of the VLookups at once to have
the new file name once I transfer the file back to my boss?
 
J

Jim Rech

Try Edit, Links, Change Source.

--
Jim
| I'm currently editing an excel file for my boss where I'm inserting a
bunch
| of VLookup functions in order for data to be automatically entered.
However,
| the file from which I'm getting the data is most likely in a different
spot
| on my computer than it is on my boss'.
|
| Will there be a way that I can change ALL of the VLookups at once to have
| the new file name once I transfer the file back to my boss?
 
Top