Hello,
If i have names in columns O1,S1,W1,AA1,AE1,AI1 etc.
I also have the same names in column B with a value in Column C when the value in C changes i have a macro to update and sort the names and values from largest to lowest.
This all works fine.
But i just can't get when i change a name in either of the column headers O1,S1,W1 etc
i want the names in Column B to also change automatically.
I would upload a sample but when i try to, it fails to upload.
Any help would be appreciated.
Show your macro code as it stands now. Remember to use CODE tags when pasting code. See my signature block below.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
This works for when i do change the names in header columns but where do i put it.
Please Login or Register to view this content.
i placed it in worksheet_change but it upsets the sort macro,and unsorts everything.
I am no expert just a tryer.
You want to integrate this with the worksheet_change procedure? If yes, then show the code for that procedure as well.Originally Posted by dealer
This is what i am using to sort the sheet.Please Login or Register to view this content.
I guess I don't follow what you want done?
Yes i guess it is a bit of a mess.
Jut want to change name in one Header column and it reflects in column B.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks