Hello Team,
Please assist me with a formula to auto fix the Author Name (Column G) once entry is made in Column B (Colour) on each row.
This is to track the entries made per user account.
Need a formula.xlsx
Hello Team,
Please assist me with a formula to auto fix the Author Name (Column G) once entry is made in Column B (Colour) on each row.
This is to track the entries made per user account.
Need a formula.xlsx
I think, if this is possible, it will require VBA. Shall I move the thread for you?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Please how do you mean by move?
You posted in the Formulas & Functions section - I have moved it to the VBA section. You don't need to do anything - keep posting in this thread.
Ohk, thank you Ali.
Does it mean that each color is assigned a specific Author Name? If yes, where is the list of color assignments to Authors Name?
Artik
Artik, the file is on one-driver for multiple users to access, so want to know who made the entry per each row, by the number of colours received and sold.
The colour is not assigned to any specific Author.
The colours are the items received and sold.
If the OP requires that the workbook current author is automatically added to the appropriate cell in column G whenever a cell in column B is changed, the following code would work:
Please Login or Register to view this content.
Excel 365 user. To unblock a downloaded macro-enabled workbook, go to your "Downloads" folder > right click on the workbook name > click 'Properties' > check the 'Unblock' checkbox. You can now open the workbook.
Deadlyduck, am getting below Macro name pop up when I run it.
Attachment 856822
The attachment is described as invalid so I can't see the nature of the error.
I'm attaching the workbook with the VBA code included, so hopefully it will work when you download it. You may need to 'unblock' it- see the instructions in my signature at the base of this post to learn how that's done.
Still having the same error message
check below attached.
Attachment 856840
Your attachment is invalid. Please attach it using the attachment instructions in the yellow banner at the top of the page.
Have attached the error message again, see if you can access it.
Macro Name is needed to be able to run the VBA
Did you download the workbook I uploaded on post 10? All that needs to be done for the current user's name to be added is that a cell in column B is changed using the dropdown options- the relevant code is already included in the 'Data(2)'s worksheet module. The macro is run on an 'Event procedure' (change of a cell value in the sheet) so there's no other macro in the workbook.
Yes, I have downloaded it but nothing happens in column G if new update is made in column B.
Check the attached.
When you open the workbook, do you see a message displayed just beneath the ribbon (something like 'Enable content')? You need to allow macros to run for the code to be activated.
The code is working for me when I make a change.
Also- be aware that no macros will work in Excel online, so if you are using that to edit the workbook, nothing would happen. The only way any macro would work is if you download the workbook to the desktop and open it in Excel that way. There maybe someone who can assist with OfficeScript code which might be usable in Excel online but I don't have any skills in that, I'm afraid.
The population in column G when column B is changed works for me but the name populated is yours, not mine.
Untested in a shared environment but maybe something like this.
Please Login or Register to view this content.
Last edited by ByteMarks; 01-24-2024 at 08:38 AM.
Hi ByteMarks,
The code provided is working but kindly re-write the code to suit the columns for the attached file.
The Author Name is now (Column A) and the Colour is (Column F).
Thank you.
Sure. Here you go.
Please Login or Register to view this content.
@ByteMarks,
Please test the file again and share with me.
Have copied and paste but not working.
Here you go.
@ByteMarks, @deadlyduck & @AliGW
Thank you all for your support.
Really appreciate.
Best Regards.
@ByteMarks,
Have notice that if I insect a row at the top of the header (above the header), the code stops functioning.
Can you please check and re-write the code for the row.
The reason is that it's identifying the colour column by looking for the heading "COLOUR" in row 1
You can change the 1 to whatever row the header is on.
Please Login or Register to view this content.
It is fine now.
Thank you.
Best Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks