Code to copy using hyperlink

Resolved · High Priority · Version 2003

Mon 14 Sep 2009, 18:22 Delegate Mandy said...

Mandy has attended:
Excel VBA Intro Intermediate course
Upgrade to Office 2010 course

Code to copy using hyperlink

Is it possible to copy data from another workbook using a hyperlink in the current workbook to direct the code to a specific workbook.

ie. on workbook S:\systems\costing is a hyper link to S:\Dev\H&P. Workbook H&P has a worksheet call assembly.

I want to copy data from this assembly sheet into the costing worksheet for each workbook created in S:\Dev. The file names change on a regular basis so I dont want to go into several different bits of code each time.

Fri 18 Sep 2009, 09:18 Trainer Jacob said...

RE: Code to copy using hyperlink

Hi Mandy

Thanks for the detail around what you are trying to achieve, this cannot be done using hyperlinks. Code would have to be written that would cycle through all the files in a directory, open them and copy the data into a workbook. Without spending more time on this we are not clear on how this could be done, but it would take several days to set up.

We can assist with this in a consultative role should it be something you wish to pursue.

regards

Jacob

Thu 24 Sep 2009: Automatically marked as resolved.

Excel tip:

How to select certain data in an Excel 2010 workbook

If you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique.

For example: If you want to select all data in cells A2 to E10, then click on cell A2, hold down the Shift key and click on cell E10 and all the data you want to see is highlighted.

Keep holding down the Shift key and you can move from cell E10 to any other cell in the spreadsheet.

View all Excel hints and tips

Code to copy using hyperlink

Code to copy using hyperlink

RE: Code to copy using hyperlink

Excel articles

Excel tip:

How to select certain data in an Excel 2010 workbook