I need a macro which moves data from one sheet to another sheet based on specific values of a sheet.
Data (sheet 1)
1___2___3___4___5
7___9___3___3___6
9___9___3___2___5
Inputs (sheet 2)
1___4
9___3
9___5
Output (sheet 3)
1___2___3___4
9___3
9___9___3___2___5
Last edited by buntalan80; 02-26-2013 at 12:54 AM.
Unable to understand the logiccan you please give a brief about it?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
On the inputs sheet, there are two values. Those two values, are the same values found on the data sheet. If you look at the example, on the inputs sheet for the first row the two values are 1 and 4. On the data sheet for row 1, data(1,1) has a value of 1 and data(1,4) has a value of 4. I need the macro to move all of the data from data(1,1) through data(1,4).
I hope this helps explain my contortion.
Thanks for the brief and before writing the macro please attach a sample workbook for understanding the data structure and cell references.
Here's a sample file. Thank you
Try this code...
Please Login or Register to view this content.
Thank you so much. Worked as advertised.
Glad it helps you and thanks for the feedback
You deserve the positive feedback and you earned every bit of it!!! Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks