sg2209
04-20-2021, 09:24 AM
Hi,
I am learning VBA and excel formula, looking several videos on you tube .
Need help on the attached file please review and help me with the below queries
create a dropdown with country names
once country names are selected, display Order id, product, category and Amount in the sheet
Also display Sum of Amount in a cell
Highlight the rows (make font red) for cells having amount less than $1,000
Data must be sorted in ascending of Order ID
Make all the data centre aligned in the column
I am learning VBA and excel formula, looking several videos on you tube .
Need help on the attached file please review and help me with the below queries
create a dropdown with country names
once country names are selected, display Order id, product, category and Amount in the sheet
Also display Sum of Amount in a cell
Highlight the rows (make font red) for cells having amount less than $1,000
Data must be sorted in ascending of Order ID
Make all the data centre aligned in the column