Collection of Data from different ranges to one range
Dear Masters, Salute to all of you..
I am making daily sale report as in my sheet attached..daily i have to copy and paste down and fill it up as per my sale..
But i also want that my this all data should go to my sheet name" My requirement" collectively without any space but date should appear infron of each day..
Hope you will understand when you will open my sheet..
Thanks in advance for any help..
SAMPLE.xlsx
Last edited by tariqnaz2005; 05-19-2011 at 11:06 AM.
This little macro will do it for you, just click the button at the top to update the MY REQUIREMENT sheet with any new items. New items will be added to the bottom of the existing data.
Please Login or Register to view this content.
_________________
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!)
Thanks a Lot dear..
You always helping me..i have not words to thank you..God bless you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks