Good morning,
I have attached a sample workbook. On sheet1 I have inventory items, I need a VBA code to copy only certain items with its corresponding row to sheet2. I believe something similar to a vlookup can be used. I would like to call the items to sheet2 by column A (Part#). Rows will change so i am not able to just call out a row.
To clear things up I would like only the data from Item2, Item4, and Item9 to be copied to sheet2 with all of it's columns (A:F)
Book1.xlsx
Thanks in advance!
Hi,
Not sure if i understand what you need here, what is the trigger to copy rows? Is it always going to be copy row if column "A" contains string text Item2, Item4 or Item9
Regards
Steve
Steve,
I plan to just add a button on sheet 1 to always copy the same row of item info no matter where they are in the sheet. It will always be the same items (ex. Item2, Item4, and Item9) so I was hoping I could make some kind of list in a VBA. I can accomplish this by =Vlookup("Item1",Sheet1,A:F,1,False) but it would be too much to do in every cell.
I think something like this is possible, but i can't be sure.
I hope this answers your question
Thank you
Last edited by MICowboy13; 01-09-2014 at 11:10 AM.
Maybe:
Please Login or Register to view this content.
Hi,
This is a bit crude but it seems to work, should help if no one else can give a more elegant bit of code.
RegardsPlease Login or Register to view this content.
Steve
Last edited by Steve@Rugby; 01-09-2014 at 11:38 AM.
Go with John's code if i were you. I'm just a beginner!
Both of these accomplish what i was looking for. Thank You John ans Steve!
If you have a few extra minutes i could use a code for to add the sum of column F to cell "G2". If not that is okay too.
You're welcome, try:Originally Posted by MICowboy13
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks