Posts by Rurkz

option 1 sounds better lol

Ya when i delete the row in outstanding bins, it leaves the rows empty between the header and the next populated row if values are replicated from the main sheet

very grateful!!!!!

ok i noticed one lil thing

the function that replicates the row from "Main sheet" to the next available row in "Outstanding Bins" and "Overweight bin" only copies to the next available row downwards, not upwards.

So if i delete the information in row 3 in outstanding bins sheet and overweight bin sheet, and add another row of information from the main sheet that copies to outstanding bin sheet or overweight bin sheet, that information replicates to row 4, not row 3..

then again, it may not need to be tweaked because i can sort it?

i will test it out for the rest of the week!!, you are awesome, a god in excel!!! "on bending knees", i salute you!

omg thank youuuu sooo much, you were so patient with me, you have no idea how grateful i am!!!!, this is so helpful for my businesss!!!!

omg god you DID IT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Quote from Carim

Hello again,

Before diving into some quite complex issues, can we agree on a couple of initial points :

1. The 4 Colors you have picked are the ones to be used (and RGB coded) ... i.e. you do not intend to regularly change colors ...

2. What would be your ' natural sequence ' for these 4 Colors ?

seems to me... you would go with : Green - Red - Yellow - Blue ... is that a good starting point ...?

Display More

these will be the regular colors ill be using

and yes that is a good starting point

You are awesome ???????????

forgot to mention, the only column i want to sort base on values will be Column A

i hope that helps

just got in, here i go!!! lol

ok attach is fake data

as you can see there is different rows colored in random order. when this is ready ill have 37 rows ready to be filled in which will continue to grow, and instead of scrolling up and down looking for a paid bin, a delivered bin or a collected bin, i can sort them by color from the top.

Now lets say i want to organize all the row paid bins in green. I will double click the Date Paid Green Header and it will sort them from the top.

Now lets say i want to organize all the row delivered bins in red. I will double click the Date Delivered Red Header and it will sort them from the top.

the Date Collected Yellow Header and Overweight Fee Blue Header will follow the same function

"Because, as you know the colors are generated by the values ... so sorting the Values should also sort your Colors"

what i noticed is, when i doubled click the headers, it sorts the value but it doesnt group and sort the colored rows together. Is it possible to sort the colored rows without using the inputted values to sort?

Now for the replication to other sheets

the function to copy from the Main Sheet to Outstanding Sheet is correct!

"should only be done IF Date Paid (Column F) was empty"

but

the function to copy from Main Sheet to Overweight Bins is different

"should only copy IF Overweight Fee (Column L) was filled in"

Damn I never got this notification....

1. I will double check the sorting again when i get home. I think what's happening is

Let's say

date delivered is filled in for 4 rows(red)

And for another 4 rows(yellow)

Date delivered and date Collected is filled in.

When I click on date delivered, instead of grouping the red rows together it grouped

2 row red at the top

1 row yellow

2 rows red

1 row yellow

Instead of grouping all red rows at the top and all yellow rows at the bottom depending on ascending or descending.

2. That logic is correct if I deliver a bin and pick it up without getting paid and it copies to outstanding bins

But for overweight Fee, there is no restrictions, when i type a value in that cell, it copies right away

ok so are you ready lol

the sorting works, but its sorts what values are in the columns cells. what im aiming for if possible is to sort the row colors instead

also i noticed something when replicating the overweight fee to the overweight sheet.

it does this only when date delivered, date collected and overweight fee are is filled in.

that function works perfectly!

but lets say i fill in date delivered, date paid, date collected, and then overweight fee, it doesn't replicate.

hey just got in, going to test it out!!!

it works perfectly, time for the multi-flexible Sorting feature lol

ok the copy color challenge is officially completed lol yeaaaaaaaaaa!!!!!!!

i mean have the row turn green when i input the value in date paid specifically in those spreadsheets

it works now!!!! awesome!!!!

the last color change option is for outstanding bin and overweight bin spread sheet.

simply have those rows change green when i input a value in date paid.

its not functioning on my end, the row is stuck on green....even if i input a value for date collected and overweight fee

ok just looked over the file,

replications to other sheets works perfectly

along with the colors

but when i inputted date delivered(red) to date paid(green) to date collected(yellow), it didnt change yellow.