transpose data for each brand if there is different price based on sheet name

Hi
I want showing data from row6 based on sheet name in B2 in PRICES sheet.
so should search for different prices in column F for the same brand is existed in column B .
if there is the same price for another date or the same date then should ignore the price is repeated.
just show the brand contains different prices ,otherwise should ignore the others brands if contains the same prices or just contain one price.
should fill empty cells by hypen and clear data from row6 when run the macro every time to update data .

Geez...You've had so so so many threads with similar requirements...By now you should at least know how to string a little bit of code together...Not even prepared to try?
Give a man a fish...He'll eat for the day...Teach a man to fish..........

Please Login or Register  to view this content.

Uses a sheet "TEMP" which is hidden.

The attachment runs OK for me. Are you using different data?

Try

Please Login or Register  to view this content.

@ John...I got same error with your code...Post above does solve though...

@ abdo...

if there is the same price for another date or the same date then should ignore the price is repeated.

This below refers to above comment...
03/02/2024 BS 1200R20 G580 JAP SDF1104 CRTE104 500.00 1,760.00 880,000.00
04/02/2024 BS 1200R20 G580 JAP SDF1105 CRTE105 120.00 1,760.00 211,200.00

Why then do you include it in your result...?

Untitled.png

Or...If you are including only the first entry and not duplicates then why do you not add the first entry here below...

Untitled.png



Also...Your dates in result does not match with dates in data...?

Uses a sheet "TEMP" which is hidden.

And TEMP sheet is cleared at end of macro.

"TEMP" is simply a "working" sheet: data is copied from sheet named in B2 [ "PURCHASES"], Sorted and prcocessed in "TEMP" and the results are copied back to "Prices": then "TEMP" is cleared.