Hi,
Is it possible to have more than 1 macro in a spreadsheet?
Here's what i want.. (please see spreadsheet attached)
1) I want to have 2 buttons on the on the black tab.
a) One that pastes info from the yellow tab (paste columns C through N) on to the report on the black tab.
b) the other to paste info from the purple tab (paste columns A through L and P through R) on to the report on the black tab.
Can you please help me do this? Thank you.
CB
Hi
You can have literally hundreds of Macros an a spreadsheet.
When you start using Userforms you will find out what I mean.
Please Login or Register to view this content.
Last edited by mehmetcik; 10-09-2015 at 02:27 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
So when we copy from these tabs to the black tab they will be filtered?
The black tab will be empty when this process starts?
If the black tab is not empty when the process starts which column will always have data, since we need to determine the last row with data so that the new data will be pasted below this row.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
thanks for getting back to me so quickly skywriter..
To answer your inquiries above...
Yes, i want to be able to filter if possible.
When the process starts the black tab will be empty. And then when i press the appropriate button(s) then they populate from the black and purple respectively.
Thanks for helping.
Your header names are not necessarily the same on all these sheets, so please verify which data goes where on the Invoice Audit sheet.
In other words Renewal Report columns C through N goes to columns X through X on the Invoice Audit sheet etc. Do this for all data you want copied. I have most of the code written but it's not obvious to me where you want to copy to.
My apologies skywriter..
Here you go...
Renewal Report columns C through N goes to columns A through L on the Invoice Audit sheet.
Transactional Report columns A through L goes to columns A through L on the Invoice Audit sheet.
Transactional Report columns P through R goes to columns M through O on the Invoice Audit sheet.
Here's the code and the sample file with the code installed.
Test it and let me know if there are any issues.
Please Login or Register to view this content.
SOLVED this is just perfect!!
A billion thanks skywriter, you ROCK!!
Everyone, if you want quick accurate answers, reach out to skywriter.
You're welcome.
Please click the Thread Tools drop down box above your first post and choose solved.
One last thing skywriter,
Is there anyway to have the button on the invoice tab, copy the info from the renewal report tab, that only shows the items confirmed (in green)? see new attachment added here. Please and thanks.
So these green cells are only green because you colored them green or is there something different about them? Maybe the status column?
I forgot to make the code work with filters, so I changed it.
If you can filter your sheet because of something like the status column to get those green cells by themselves, then this code should take care of that.
Please Login or Register to view this content.
Last edited by skywriter; 10-09-2015 at 06:16 PM.
The green rows are the "confirmed" rows. Those are the ones that need to be copied to the black tab.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks