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
Excel
Resolved · Medium Priority · Version 2003
Mon 12 Apr 2010, 16:57Delegate Silvera said...
Silvera has attended:
Project Intro Intermediate course
Excel Intermediate course
Excel
I have a list with extensive data (almost 3000 rows and multiple columns). It relates to properties within a BLOCK that a STATUS and FLOOR LEVEL.
I want this data to be be summarised in a more digestable form (on another worksheet) that maps out the BLOCK and where the properties are located and then colour the property (cell) depending on the STATUS
i.e. it would almost look like an elevation diagram of the block.
I hope the bove makes sense (and is possible within the MS suite)
I hope to hear from you soon.
Regards,
Silvera
Wed 14 Apr 2010, 11:27Trainer Anthony said...
RE: Excel
Hi Silvera, thanks for your query. Two things spring to mind. The first is unless you're going to manually copy and paste data into a new worksheet and BLOCK structure, it would be much quicker and more efficient to do this using VBA. Secondly, you could use conditional formatting using "Formula Is" to colour records according to their status but again, if you're going down the code route it would be better to include this in the VBA subroutine itself.
Hope this helps,
Anthony
Wed 14 Apr 2010, 11:28Trainer Anthony 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.
Fri 16 Apr 2010, 11:11Delegate Silvera said...
RE: Excel
Thanks for your reply.
I have no idea what VBA is but will look it up...
Fri 16 Apr 2010, 12:28Trainer Anthony said...
RE: Excel
Hi Silvera. VBA stands for Visual Basic for Applications and this is the sort of thing you can expect to learn on one of our VBA courses:
https://www.stl-training.co.uk/excel-course-in-london-2003-vba.php
It's very useful stuff! Start off by investigating the macro recorder to automate repetitive tasks, then when you've got used to that and want to do more sophisticated processing of your spreadsheets you can progress to VBA.
Hope this helps,
Anthony
Fri 23 Apr 2010: 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. |
Excel tip:Recovering Unsaved Work in Excel 2010Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back. |
