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
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
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.
RE: Excel
Thanks for your reply.
I have no idea what VBA is but will look it up...
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
