create a button that automatically fill a table from a dataset

[netha]

Hi,

i have two columns 'PO Date' and 'SO Date' . i want to add a button to get the difference between the two dates per row and fill a table mentioning what are the min/max dates for a one product category( i.e. Fabric,Accessory and trims). i have attached the data sheet herewith. please help!

thank you

[oeldere]

Maybe with an pivot table.

See the attached file.

[breadwinner]

hi netha find the attachment
OM CT netha (oeldere).xlsx
if you satisfy please give rate for my thread thanks to you

[oeldere]

@breadwinner

I don't mind you use my file (or solution) for your post.

But can you also post (e.g. as text in the treat) the changes you made in the file I posted.

Since I take a look and don't see any differance.

And if there are better options, i'm willing to learn

[abousetta]

It looks like he uploaded your file by accident because the file names are the same.

[oeldere]

@abousetta

As already said I don't mind they use my file for that purpose.

But if there are changes I would like to know, so I could learn from it.

I hope breadwinner takes the time to respond.

[abousetta]

No, what I mean that they probably downloaded your file (to see your solution) and by accident instead of uploading their file they uploaded your file along with their post. It wouldn't make much sense for @breadwinner to upload your file (with your name on it) and claim that this their own handiwork Of course, who knows... maybe they are after your rep points

[breadwinner]

sorry dude instead of download actual posted file i downloaded your file it was happened by mistaken...

[netha]

hi oeldere
thanks for your reply. sorry i forgot to mention that the min value must be >0 to be considered (results should be same as in the example table in the file). please help me to use pivot table in this situation.

netha

[oeldere]

See the attached file.

[netha]

ah so you added a new column right? thanks for the reply is there anyway we can get the 'CT new' column result in to 'CT' column without adding that extra column?

[oeldere]

ah so you added a new column right?

Yes I added a new column to the datasheet.

is there anyway we can get the 'CT new' column result in to 'CT' column without adding that extra column?

Maybe there is, but I would solve it with the extra column.

What the problem of that?