Sorry to hear about your trouble - trust it won't have caused too much damage.



There is no great rush about my last questions - so don't feel under any pressure to let me have a quick response.

I forgot it was Wednesday . Everything shuts down at lunchtime on a Wednesday here, which put paid to my shopping expedition, so I spent a few minutes adding a date selection to the userform.

The damage I have discovered so far is a lot less than it might have been. An electric kettle was fried. A few fuses blew. My satellite TV boxes are fried and the internet was taken out, but because the surge protector did its job, there was no damage to the PC, and the telecoms company have checked out their modem and that too is OK. I can live without satellite TV, thanks to the internet.

The function which reads the worksheet names doesn't like spaces in the names, as yoiu have discovered. It is easy enough for you to change the space for an underscore before using the function.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Glad to hear that things aren't as bad as first feared. It's an ill wind....... Sorry about the pun!!!
Thanks for looking into my questions - did you intend to attach a file with the date selection?

Ah- That would have been useful.

Attached Files

Process.xlsm (66.4 KB, 11 views)

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Sorry I didn't get back to you yesterday - I had other things to attend to!!
Thanks again for all your help - it has been brilliant. I have been able to modify what you provided to do other useful things! Your input has been invaluable.
I have now marked this as solved.

I'm not sure whether it would be breaching any Forum guidelines, but I would like to pick up on this thread which Graham Mayor solved for me just over a year ago.

I am trying to modify the Process actions in order to link some different files. The original solution has worked very well. But what I now need is to modify the code so that 3 fields (not just 1) in the 2 files ('Bank' and 'Donors') have to be linked. I am unable to trace in the code where the necessary changes need to be made - and I'm not even sure that what I need will be possible!

Am I right in also assuming that the 'Bank' and 'Ledger' files can be the same? In other words I would like to add some data to the 'Bank' file based on information in the 'Donors' file instead of inserting it into the 'Ledger' file.

If you need me to provide the present coding I can do that, but it is in the file that Graham posted in his penultimate message on 26th November.

It's been a long time since I looked at this and looking at your follow up question, it is not clear what you are now asking. If you mean that you want to use just one workbook to replace the three (Bank, Donors & Ledger) then you can do that, as long as the they are on separate sheets. Beyond that I don't know what you require.

The process works by reading the worksheets into multi-column arrays which are interrogated to produce the required results, which are then inserted where they need to be.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Sorry my last post wasn't very clear.
This is the present set up -
In my Donors table the 2nd column contains the same information as is in the 2nd column of my Bank table. And so the coding that you provided me with made that link and allocated the money received from each donor in accordance with their percentages for each of a number of projects.

What I am trying to do -
1. In the Donors file the 4th, 5th & 7th columns contain the Name, Surname & Postcode for the donors.
2. In the other file (let's call it 'Tax') the same information is in the 2nd, 3rd & 5th columns.
3. The combined information in all 3 fields must be unique - there can be donors with the same Name & Surname but with different Postcodes so that is why I need to check all 3 fields for my latest project.

So my question is - can the VB code provided a year or so ago (which is working perfectly) be easily adapted to check the 3 fields instead of just one?
And I assume that if I use the same file (say 'Tax') as the 'Ledger' I will be able to get the result of applying the percentages from the Donors file to be added to the tax file.
I trust this helps to clarify what I am trying to do now.

Easily? No! That would be an entirely different project, albeit based on similar principles. The 'Donors' file description does not even match the sample donors file used by the earlier project.

If you want me to quote for developing a second project, please contact me via my web site.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

I wondered about that!! I'm exploring whether I might be able to establish another way of linking my files which would avoid a major exercise. I'll be in touch if I need to follow up your suggestion.

Just to advise you that between my son and myself we have resolved the issue. We are using Concatenate to combine the 3 fields into one and then Lookup to pick up the percentages and apply them to the Tax.