Hi, I wonder whether someone may be able to help me please.
I've been trying to find a solution to this all day without any success, so it's left me a little perplexed.
I'm using a spreadsheet called 'Resource Summary 12-13'. This sheet profiles staff resource across the year, and by...
Hi @Marc, thank you very much for taking the time to reply to my post.
I was lucky enough to receive your reply and another from the sister site 'VBA Express' with the same answer, and it works great.
Once again many thanks and kind regards
Hi all, I made a mess with the cross posting.
Since my original post on this site I have done some further work on this. I now have a script which copies and pastes the correct information as shown below.
Sub Merge()
Dim DestCell As Range
Dim DataColumn As Variant
Dim NumberOfColumns As...
Hi, my sincere apologies, I wasn't aware of this. Although the code samples are different, they are for the same task. I have marked the other post as 'Solved.
Once again my apologies and thank you for pointing this out.
Many thanks and kind regards
I wonder whether someone may be able to help me please.
For some time now, I've been trying to put together a macro which allows the user to select Source Files by way of a button select in the 'Destination (Master File). VB is not my strongest subject, so I've not been able to get this to...