I have a master list that I want to type repair orders into. I want that list to auto populate the appropriate worksheet. I have only one criteria and that is to sort by truck or trailer number. I have tried a small macro and an amazing if then list but I just can't get it to work. Can anyone help before I spend a fortune trying to get someone to do it for me?
Thanks
There is no code attached and not clear which columns/rows do you want to merge.
Let me see if I can see what I did that got the farthest. It was a small macro that was suppose to copy and paste the row when it met the criteria. I could get it to copy but then ran into an error.
Moderator Note:
Please Login or Register to view this content.
Pls use code tags around your code next time as per forum rules.
Last edited by Fotis1991; 09-26-2013 at 12:27 PM.
1m happyGirl,
Please use code tags with your code as per forum's rule.
I am afraid, your code does not do much. Please explain what are you trying to do and better if you could attach a sample of desired result.
Last edited by AB33; 09-26-2013 at 10:42 AM.
I want to be able to enter data on the master sheet and then have each line pasted to the appropriate truck. I have filled in two lines on the master sheet and if you go the pages you will see that I manually pasted the information. I want it to be automatic.
The main code sits on the module, but the code which fires the main code resides in master sheet. If you make any change in column A of master sheet, that row will auto copied in to respective tab. I have tested it and it works.
Oh my gosh!
Thanks you so much...I appreciate it... I have been wrestling with it for two days now!
Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED",as per our Forum Rule #9. I will do it for you this time.
In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.
Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.
Also remember to use code tags around your codes.
Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
That option is not available under my thread tools
The option is available and pls use it next time according rule#9 of our forum.
Currently, the only options I have viewing are Show printable version, email this page, unsubscribe from this thread, add a pole to this thread and mark this thread as unsolved. I went back to try to mark it but it isn't available. You don't need to be mean or nasty...and I am aware it is a rule.
You have the mark as unsolved option because i used the mark as solved option to mark your thread as solved.
Last edited by JBeaucaire; 09-27-2013 at 10:08 AM.
For the sake of clarity...
http://screencast.com/t/d6NQ4v6D0U
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks