98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel help!!
Excel help!!
Resolved · Urgent Priority · Version 2010
Fri 11 Oct 2013, 10:25Delegate Ranyere said...
Ranyere has attended:
Excel VBA Advanced course
Excel help!!
Good morning,
I'm having some trouble to solve a couple of tasks and was wondering if I could get some help from you guys, please.
I need to send over the files, however there is no option to attach them to this message. Would it be possible to be contacted by someone from Best STL at all?
Your help is much appreciated.
Many thanks in advance,
Ranyere
Fri 11 Oct 2013, 10:31Trainer Richard said...
RE: Excel help!!
Hello Ranyere,
Hope you enjoyed your Microsoft Excel VBA course with BEST Training.
Thank you for your forum post.
Please would you detail your query in writing, in on the forum, so we have an idea of what you are needing to ask. Once we have this, we can assess what level of support you need and if we can do it via the forum, or if another approach would be best suited.
Please would you send your file to forum@stl-training.co.uk so we have your file for reference.
Regards,
Richard
Mon 14 Oct 2013, 14:38Trainer Richard said...
RE: Excel help!!
FROM RANYERE:
Task 3
There is a file with 2 fields/columns, the first field with values ranging from 1 to 4 and the second with address values. Value 1 in the first column corresponds to region in the second; value 2 corresponds to county; value 3 corresponds to city; and value 4 corresponds to neighbourhood.
Without changing the structure given, I need to apply a function to extract all 1 values (region) and place in a new column labelled, say, Region and to the same to the others so in the end I have a new table with four fields splitting the address in a hierarchical structure.
Mon 14 Oct 2013, 16:46Trainer Gary said...
RE: Excel help!!
Hi Ranyere
Thanks for getting in touch. I've had a look at the problem and it will take some time to solve.
You should consider that you will need to store the current "dept" in an array. This array should be storing and tracking the current value in the current row, then outputting it on the other sheet.
Your array will probably be two dimensional, to store the entire address record.
It will probably also note when the dept changes in column B.
That should give you enough hints to get you started. Let me know how you get on.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Mon 14 Oct 2013, 17:17
Edited on Mon 14 Oct 2013, 17:18Trainer Gary said...
RE: Excel help!!
Hi Ranyere
I've run out of time to carry on looking at this but I thought I would send you what I've written so far.
It is nearly complete, the only issue is that the preceding values are empty - the structure is there however.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
Tue 15 Oct 2013, 09:12Delegate Ranyere said...
RE: Excel help!!
Hello Gary,
Thank you loads for looking into this!
The file you attached hasn't been modified but looks like the original file. Would you mind sending it again as it looks like your work was corrupted.
Many thanks,
Ranyere
Tue 15 Oct 2013, 09:15Trainer Gary said...
RE: Excel help!!
Hi Ranyere
Make sure you enable macros when opening the file, then run the "AddressSplit" macro.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Tue 15 Oct 2013, 09:37Delegate Ranyere said...
RE: Excel help!!
Awesome - I can see it now!
Thank you, Gary, much appreciated.
Regards,
Ranyere
Tue 15 Oct 2013, 10:28Trainer Gary said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Tue 22 Oct 2013: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
