How to automate transfer of data from masterfile to another sheet based on model no.

[CanCanKen]

Dear All,

Hope you guys are doing well.

I am not an expect in excel, I really hope you guys can provide me some sort helps/advise/how to automate this process.


Okay, basiccaly I need to send an order to our supplier whenever I received order from my supervisor - at least twice a month.

I have this master file contains of data such as - model no., description, finish tye, price, carton sizes, etc etc and it has about 100-200 lines model on it per supplier(different supplier different masterfile)


Once i received an order from my supervisor, I need to create a new order says 58 items this round from this supplierABC, normally i need to go to this supplier ABC masterfil and do a search of the model no. and copy and paste the entire row in the new order table.

You can imaging how much time spend of doing this when sometime I will receive like 50 order in a days and I need to send out to different supplier the next days.

All this manual works is driving crazy and took up a lot of my times.

Please refer to the attached sample ABC master file.

sheet 1 is where the database/masterfile list and
sheet 2 is where I created the order and need to send to the supplier.

I really appreciate if anyone out there able to helps me on this, not sure whether macro, some formulars, VBA scripts or advanced copy able to simplify this process. Once I input the model no. the rest of the data will auto populate in the new order sheet2 table instead.


thanks.

[mrshl9898]

Hi,

There was no info for CR88ABC so I returned a result of XXXXX, apart from that look at the attached and let me know what else is needed.

[AliGW]

Rule 08: Cross-posting Without Links

Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

No further help to be offered, please, until the OP has complied with this request.

[CanCanKen]

Hi mrshl9898,

thanks for the help. I tried out your vlook formulas everything seems working well. Awesome job mate.

Hi AliGW,

I didn't know I need to do that, This is my first forum posting asking for some helps.

Will remember to cross posts/provide other links, if I have any other query in the future.

Sorry about that. ...

[AliGW]

When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.

(link above in the menu bar)