Macro to sort a dynamic list

A

alis88

New Member
Joined
Aug 5, 2008
Messages
3
Morning all

I was wondering if someone would be kind enough to provide me with a solution to my problem.

I have a workbook which contains three worksheets.

There is an ENTRY worksheet, which contains a list, which the user uses to enter details of a new product. The user adds the product to the end of the list already there. One field which must be filled is the "Status" field, where the user selects whether the product is either on sale, or sold-out.

The other worksheets (ON SALE and SOLD-OUT) display the list of the relevant materials from the ENTRY sheet, i.e. a list of all materials sold-out, or all materials on sale, but these worksheets must be sorted in alphabetic order.

Basically, the ENTRY sheet contains all materials unordered, and the other sheets contain only relevant materials ordered.

The sort must be by material ID. It must be immediate (i.e. no need to "refresh" the workbook), on click of ON SALE or SOLD-OUT.

Can someone please help me with a macro for this?

Thanks in advance.

Alis
<!-- / message --><!-- attachments -->
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Sort by date Sort by votes
I would recommend your ON SALE and SOLD-OUT sheets contain Pivot Tables which read from your ENTRY sheet.

You can use a dynamic named range to ensure the Pivot Tables always pick up all data.

You can set the Pivot Table page fields to "on sale" and "sold-out" in the relevant sheets.

You can use

Code: 
Private Sub Worksheet_Activate()

ActiveSheet.PivotTables("MyPivotTable").PivotCache.Refresh

End Sub

in the code for each of the 2 report sheets to automaticaly refresh.

HTH
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
Filter Function Problem Handling Negative Numbers
Replies
7
Views
689
Peter_SSs
Peter_SSs
V
  • Question
VBA Code that uses CustomOrder to Sort in other Worksheet in the same Workbook
2 3
Replies
25
Views
816
Legacy 143009
L
T
  • Question
Optimising my VBA to improve the efficiency of my Workbook
2 3
Replies
21
Views
1K
Tmini
T
V
  • Solved
VBA Macro Copy and Paste
Replies
3
Views
450
kevin9999
K
H
  • Question
Create a ticket sales management system
Replies
1
Views
283
Harvey12
H

Forum statistics

Threads
1,215,103
Messages
6,123,110
Members
449,096
Latest member
provoking

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top