Hello Experts,
Need your help in building a formula or code to move data from "Input sheet" to "Final Sheet" on the basis of values specified in "Index Sheet".
For example.. In Attached sheet
User have mentioned Column Name ("Date")& Required Data from the column specified ("Date").
Now on the basis of this parameters the rows should be moved to final sheet..
USer Can select any column name & any value, if the data is present it will be moved to "Final Sheet" else not.
Please suggest
Last edited by Parth007; 12-01-2016 at 06:59 AM.
Regards
Parth
I appreciate your feedback. Hit * if u Like.
Rules - http://www.excelforum.com/forum-rule...rum-rules.html
In your "Source" tab you have two dates in column E which are the same (20/10/2016). This means that your "Final" sheet should also include the data for EMPID1. Is this correct? In your sample file, this data is not included.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Hello Mumps1,Originally Posted by Mumps1
Yes it should include, sorry i missed to move that row in final sheet. Sorry about it.
Last edited by Parth007; 11-28-2016 at 11:14 AM.
Try:
Please Login or Register to view this content.
Other 1
Kind regardsPlease Login or Register to view this content.
Leo
Thanks Mumps1 & thanks LeoTaxi.. the code worked as charm..
One question...
now this code gives what we specify in required data.. what if we want data apart from what is not specified in required data?
Hi LeoTaxi, Columns may be more or less,
& now this code gives what we specify in required data.. what if we want data apart from what is not specified in required data?
Last edited by Parth007; 11-29-2016 at 06:20 AM.
For data not specified cange
toPlease Login or Register to view this content.
for more or less ColumnsPlease Login or Register to view this content.
the array arr contains all Columns, so the array sn can be loaded with the same or less columns
in exemple till 5, you can fill the sn(j,6) the sn(j,7) the sn(j,8) enz....
in this case change also the number of Columns
KindPlease Login or Register to view this content.
Ok Thanks.. will update accordingly
I have this code ready.. attached is the Macro file..
The code works perfectly for small(less) data.. but if columns are more or if rows are more then this macro code doesn't give correct answer..
can anybody please suggest what needs to be done to rectify the code..
attached is the macro
Note : -
1) CommandButton1(Move Required) - gives data what we specify in required data (Column E of Index Sheet)..
2) CommandButton2(Move Difference) - gives data apart from what we specify in required data (Column E of Index Sheet)
Last edited by Parth007; 12-01-2016 at 06:59 AM.
For variable qt Columns
Kind regardsPlease Login or Register to view this content.
Leo
Re: Move data to other sheet on User input
Forget code in # 11
worst thing i ever made, i see now
think this will do the job
Kind regardsPlease Login or Register to view this content.
Leo
Fabulous Leo... simply superb.. worked like charm.. thankfull to you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks