Posts by frankximus

    Re: Colour code the data range after data is filtered and pasted from another sheet

    Hey cytop,

    Thanks for your prompt reply!

    I think I might need to expand on that a bit since this won't be direct define of colour.

    Here are the codes I've used in the sheet.

    I'm trying to come up with a way to auto color the cells whenever a new set of data is pulled out of the data sheet. This is for purely visual differentiation. Since the position of the pulled data varies, I'm wondering if there is a way/code to auto color the range of cells that were active? (this range varies automatically)

    Hey guys,

    I've got a workbook with coding that pulls data from another sheet by criteria, however I want to be able to color code the whole data pasted so that they are differentiated visually from each other (Math has red, Geography has yellow etc...) in the display sheet.

    So far I've found a code that color codes the cell's background which is limited to the active cell, does anyone know if I can apply to the whole range? Say when data is pasted into A3:B4, then the whole range is color coded as red?


    Hey guys,

    I'm trying to build something that pulls data directly from another sheet by filtered criteria. If the criteria matches, then data is pulled into another display sheet. However, my challenge is that whenever the data is pulled, it overlaps with each other.

    Is there a way or code that can make it smarter? Say if under the 'Math' there are lots of data, then the row starting 'geography' automatically goes down to avoid overlapping. Can anyone give me some directions as to what function to search for things like this?

    I've also posted the same question on another forum seeking a smarter way of coding, link is attached below.…sheet-based-criteria.html

    Thanks heaps guys!