move data between sheets by specifing certain criteria

[stimy2001]

I am new to the post so far I love it. I am in need of a formula to help with an order book that I created in excel. In first sheet in colum A is the item number, in B is the Description, in C is the count, in D is the selling unit PK or Ea, and in E is the class code. I have sheets for every class code. I need to be able to pull information form the sheet one that matches the class code in colum E and only the items and info for a certain class code and post it to another sheet that has all the headings and formatting that I need. I need all the rows that have the same class code to be pulled excatly the way it is in sheet one. I thought I might be able to do this with vlookup or dget but can't seem to figure it out. I hope I haven;t confused anyone. If you need more info or the data I can get it to you. Any help with be greatly appreciative. Now i am copying and pasting the data that I need but this is very time consuming.

[NBVC]

Welcome to the forum,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[shg]

Welcome to the forum.

Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.

[stimy2001]

sorry about that. I think this will help

[shg]

Much better, thank you.

Chances are VLOOKUP will do what you need. Post a workbook and explain in context.

[stimy2001]

Here is a sample pf my workbook mond you that it is a lot bigger than this. Hope this helps.

[shg]

Now you need to provide an example of what you want.

[stimy2001]

I would like for in sheet 1 colum e for all the data in the row coresponding to e to be transfered over to code 1 sheet. For example all the 1's in colum e should be tranfered to the shett named code one.

[stimy2001]

anyone got any ideas???

[shg]

I have one: You could explain what data goes in what columns, if it replaces existing data or goes at the bottom of data that's already there, ....

In short, imagine we know nothing about what you want (we don't) and you take it from there. No one wants to play 20 Questions to find out.

[stimy2001]

Sorry I will try again. In the worksheet I have 4 sheets in the 1st sheet called sheet1. In that sheet I have 5 colums all the data is different except the last colum "E" it changes but some of the data is the same. I would like to be able to go to another sheet and copy the data from sheet one in the new shett ony of it matches the criteria in colum"E" for example I would wnat to pull all the data that has an 1 in colum "E". By the way the data in the row that coresponds to Colum E need to be the same. For example in A1, B1, C1, and D1 I need all that data transfered to A1, B1, C1, and D1 of the new sheet if colum E is 1. Hope this helps please leet me know. Thanks

[stimy2001]

what do you think???

[Charles]

stimy2001,

Like the previous post from Shg. You are not really telling what you need. When I looked at you workbook for sheet Code1 I see several columns A thru Q, and yet you said you need columns A thur D from Sheet1 to columns A thru D in code1 for the value of 1 in column E of sheet1.

[stimy2001]

First of all the data in colum e is the class that the product is in. I need to be able to pull the item#, Description, and so on. so that in the sheet titled class code 1 will be the items in class code 1 that corresponds to colum E. The reason I need this is the master orderbook is in sheet 1 and it is constantly changing and I need to be able to seperate the different class codes in E to different sheets. In other words I need to be able to copy and past A through D if E has a one in it to another sheet labeled class code 1. And the same for E if it has a 2 to another sheet labed class code 2. I am sorry that this is confusing it is hard for me to explain something like this without showing it face to face. I would be a terrible teacher. LOL. I hope someone can help me.

[NBVC]

See attached:

I entered the code in F1 of each sheet for reference.

I entered a formula to count number of matches to the code in H1, again for referencing:

=COUNTIF(Sheet1!E:E,$F$1)


Formula in A3 of each sheet:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER and not just ENTER and then copied across 4 columns and down to row 100...

You can change the ranges in the above formula to suit the quantity of data you actually have..you will need to re-confirm the formula with the CSE keys to get the { } brackets to appear and then copy across and down as far as you require.

[stimy2001]

The only problem woth it is I only need the brcode format in colum A .

[NBVC]

The only problem woth it is I only need the brcode format in colum A .

Please elaborate.

[stimy2001]

IN your example the bar code font carried throughout the rest of the workbook.

[stimy2001]

never mind. For some reason my work pc pulls the bar code font but my hame pc doesn't. Thanks you so much this is really going to improve my business.