Hi Experts ,
I need a help via VBA , because contains 70+ excel sheet and will be very difficult to put formula in every sheet.
In the attached sample.xlsx one sheet named Rawdata all the data is reside on this sheet , required to copy data based on Column A and Column B of rawdata sheet to multiple data sheets containing similar column A data and Column B dates. All Columns of Rawdata sheet copied to multi sheets ( the data which need to be copied in no fonts )
Hope i understand well.
This seems to do what you want:
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!)
JBeaucaire Thank you it works ...
E.g the data is not in sequence Name1 starts from row no 65 to 80 and the Date is 1/1/2017 to 1/16/2017 available in Rawdata sheet . After that no continuation the 1/17/2017 for Name1 on row no 90 so on . How can we modify the code?
Add more some times the data is not up to end of the month it breaks e.g till 1/16/2016 and then next other Well starts Name2, by running the code it copies the data which not belongs to well columnA respectively
Last edited by farrukh; 07-16-2017 at 01:21 PM.
1) Sort your data using Column A, then column B. Then macro works as is.
Thank you for your support & Help !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks