Copying data without linking sheets

chiswickbridge

Board Regular
Joined
Feb 2, 2013
Messages
118
I have a xls file, about 5Mb, in the following folder.


D:\portpaper\main\data\ship.xls


ship.xls has only one sheet called "rawdata".


I have a second file in another sub-folder of "main".


D:\portpaper\main\aus\crew.xls


crew.xls has only one sheet called "list".


Without linking the worksheets, I need a macro to import data from "rawdata" to "list"


The actual process starts as follows.


ship.xls is updated and saved with a password called 'password" and closed, say once a day.
Crew.xls is manually opened and then as required I will activate the macro, which will automatically open ship.xls, using "password" as the password, copy select data as required and close ship.xls.


I need only data from A10 to H99 from "rawdata" to be copy pasted only values to "list".


I can tweak to choose different cells as required at a later time.


Looks complicated....?


I have had linked workbooks and it has given me headaches with broken links.


Is there a better way to to import or copy paste data or my process looks irrational...
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

welshgasman

Well-known Member
Joined
May 25, 2013
Messages
871
Carry out your process and record a macro before doing it.
That would give you the bulk of the code and then you can tweak it as you see fit.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,323
Messages
5,600,954
Members
414,417
Latest member
Nobu

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