LinkBack URL
About LinkBacks
Hello,
I'm looking for help in creating a VBA Code that if a cell ='s Shipped then it cut's and paste to another sheet. As well as a data & time stamp as the last time any cell was updated. Thanks for the help
Hello,
I'm looking for help in creating a VBA Code that if a cell ='s Shipped then it cut's and paste to another sheet. As well as a data & time stamp as the last time any cell was updated. Thanks for the help
Hi Sixto2014
Welcome to the Forum!!
Which Column will contain Shipped...Column K of Orders to Follow Thru?
Do you want the Time Stamp to change for ANY change in Orders to Follow Thru?
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Yes it will be Column K that will contain this Status. Yes for any change in the Whole workbook if that's possible. Thanks
Hi Sixto2014
Place this Code in the Sheet Module of Orders to Follow. Right Click on the Sheet Tab ---> View Code ---> Paste the Code in the Right Hand Window.
Please Login or Register to view this content.
wow this is awesome thanks so much. How can I have it only on 1 cell the last time updated like on cell L2 or even if better on the name of the file all the way on the top. Anything that shows my guys hey you already updated this at such time. They are not that computer handy and i'm trying to make it as easy as I can for them. Thanks again
Hi Sixto2014
This Code populates cell L1 with the updated DatePlease Login or Register to view this content.
Do I save this as a Marco Enabled or normal workbook?
Macro Enabled
ok thanks
Is there anyway to put the last time updated all the way on top of excel where it shows the file name? Like right underneath the file name that would be cool?
If I insert a column will this update the VBA Cod, if not what would I have to update in the Code?
Thank you so much for the help
Hi Sixto2014
Regarding this...not that I'm aware...you may wish to start a new Thread for this question.Regarding this...no, the Code will not auto update; the Code is written based on the Structure of your Sample File...the Code would need to be modified to accommodate the new Column(s). WHAT needs to be modified depends on where the new Column(s) is/are located.Is there anyway to put the last time updated all the way on top of excel where it shows the file name? Like right underneath the file name that would be cool?
The Code could probably be REWRITTEN to accommodate the adding of Columns but you'd need to define why you're doing what you're doing such that we understand the logic.If I insert a column will this update the VBA Cod, if not what would I have to update in the Code?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks