Macro Finding / Finding a Sheet containing

[DakotaDK810]

Hi all, I have a two-part question on an example workbook that I've uploaded.

1. I'm trying to come up with a method to always find this sheet (Current Account Status 250). The issue is that the number on it always changes, so one day it can be 123, the next nothing. I saw an example of a code that had a Left.(name, 8)-type deal, and that's what I'm aiming for, just a VBA code that lets me always find the sheet that has "Current Account Status" in it.

2. I need the cells on the SQL Account Data Column B to be pasted onto their corresponding account #s on the Current Account Status Sheet. It's not as simple as a copy-paste between sheets, and I cannot use any type of VLookup. I was researching some areas and saw that an array may possibly help, but I'm not sure about that.

Any tips in the right direction would help immensely! Thanks!

[rylo]

Hi

See how this goes.

Please Login or Register  to view this content.

rylo