How to Merge Multiple Excel Workbooks to a Master Budget

[Sbhabhi]

A big thanks for your lovely video

[DannyRocksExcels]

@Sbhabhi

My pleasure. I am happy that you enjoyed my video.

Danny Rocks

The Company Rocks

[bjeli07]

this is exactly what i need but i seem to have some problems with merging i keep getting the error : "filename.xls can't be merged into current workbook.workbooks to be merged must be copies made from the same shared workbook" and i can't make a copy of the ORIGINAL FILE cos it's on another computer (work regarded i got half to do and the workmate got the other half) so same file same data i just need to do half and then merge them BUT I JUST CAN'T DO IT! pls help

thx!

[DannyRocksExcels]

@bjeli07

I can only offer limited help in your situation. As I understand your problem it seems that you are working from a file that is stored on your workplace server. Your Netword Administrator has probably added in several layers of protection or encryption.

My tutorial uses the premise of using a Non-Networked Excel File.

I suggest that you speak with your IT Department or Network Administrator to get advice for enabling you and your co-worker to collaborate on this project.

[TuskersVB]

Just what I was looking for thanks

[oishiiyo]

THANKS!



[DannyRocksExcels]

@oishiiyo

My pleasure.

Danny Rocks

The Company Rocks

[123789s1]

How do you make the yellow spot follow the cursor and then react to clicks?

[DannyRocksExcels]

@123789s1

The "Yellow Spot" that you see attached to my cursor is part of my Video Editing Software - Camtasia Studio. It is NOT part of the Excel program. I add the spot and the cursor effects during the editing stage for my video tutorials.

Thanks for writing to me.

Danny Rocks

The Company Rocks

[Violetta197900]

Wonderfully helpful! Thank you so much!!

[DannyRocksExcels]

@Violetta197900

Thank you. I am pleased that I could help you.

Sincerely,

Danny Rocks

The Company Rocks

[boddunah]

Thanks Danny for useful tip

[DannyRocksExcels]

@boddunah - My Pleasure. Thanks for writing to tell me that you found this tip useful.

Danny Rocks

The Company Rocks