Macro using Name entered in specific cell

JABWootton

Board Regular
Joined
Dec 16, 2004
Messages
94
Office Version
  1. 2019
Platform
  1. Windows
I am attempting to write a macro for the following
I have a list of date in various cells which are updated daily
A sort needs to be done in each worksheet where a certain person is in charge of various projects.
I can do it manually by selecting the data and doing a sort by name or I can create a simple macro where it does this for me.
As the names change monthly this is becoming time consuming as I need to change the macro to show the new persons name
What I need to do is create a macro where that persons name is entered into a cell in a separate worksheet, the macro is the run and the results are sorted in the relevant worksheet.
Any questions please feel free to ask
Thanks in Advance
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
dim name as string
name=range(...).value

e.g.f the name is tempoarily parked in L1
then
name=range("L1").value


and then work on the variable "name"

venkat
 

JABWootton

Board Regular
Joined
Dec 16, 2004
Messages
94
Office Version
  1. 2019
Platform
  1. Windows
dim name as string
name=range(...).value
e.g.f the name is tempoarily parked in L1
then
name=range("L1").value
and then work on the variable "name"
venkat

Thanks but totally lost
only used to entering very very simple macros through the record button and then amending the macro manually
how do i put the above in macro
 

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
sorry

you post an extract of your sheet and also decribe what exactly you want with respect to that extract
 

Forum statistics

Threads
1,136,712
Messages
5,677,330
Members
419,688
Latest member
sarahmichelle

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
Top