Basic Macro for copying 2 Columns from one workbook to another

I have a basic question for a macro, I've looked at other threads but they all seem to have some kind of twist to it. All I want is a macro that copies columns A&B from a source workbook to my destination workbook in a specific worksheet for column A&B too. I'm assuming that the destination worksheet will automatically update whenever the source workbook is updated? My source workbook is called Job List 7 and the worksheet is called Master Job List, my destination is Ted's Timesheet and the sheet is called Job List. If i should attach my timesheet for more info then please let me know.

Something like this might work... of course you would have to have both workbooks open for it to function correctly.

Sub CopyAB()

Application.WindowState = xlMinimized
Columns("A:B").Select
Selection.Copy
Windows("Job List 7.xls").Activate
ActiveSheet.Paste
End Sub

Is it not possible to have the source workbook closed for the macro to work? is there an alternative perhaps? The reason i want this macro is to avoid opening the source file when i need to work on my timesheet (Ted's TImesheet)

thank you! it worked.

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

Thank you, was trying to find that solve button everywhere!

I just realised that the macro is not keeping up to date with the job list? is there a formula i can add to make the macro refresh or keep up to date each time the worksheet is opened?

Maybe:

Please Login or Register  to view this content.

Worked, Thank you very much.

Once again, you're welcome. Glad to help out.