Hi, I'm trying to save some time on a spreadsheet I have at the moment by automating a short process. Basically I have two columns, items I have in possession and items I need to get. When I get an item on the needed list it has to be marked green and then copied to the other column, but left in original column. I was just wondering if there was a function that anybody had used that would duplicate a call in another columnwhen either fill our text colour is changed.
Thanks in advance
Jordan
Last edited by tucka20; 05-14-2013 at 03:38 PM.
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi, for some reason I am on the android app and it won't let me deselect solved. This isn't solved yet, so any information greatly received. Could an admin look at this for me please.
Jordan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks