Copy Data form other Sheets to Master if marked as Active

[A_TSC]

I love excel but have not had the time to really sit down and learn everything that it can do. I love playing with formulas and functions but it’s been at least a year and a half since I have had to do anything more complicated than adding and subtracting....seems all my knowledge about Excel was a use it or lose it thing....and I have forgotten so much!! Then comes this huge project across my desk and I need help!!

So basically, there is currently 16 tabs. 1 (the first one) being my "master" and the other are my sub-worksheets that contain info (dates/weights/text) in them that is specific to each job number that we have going on for the year. I need to somehow bring over the entire line (A-O) from my sub-worksheets if I indicate that the line item is currently active, and of course not come over if I indicate that it is not active. I am planning on indicating if it is active by having an “A” in column A for Active, or an “X” in column A for not Active. I don’t need anything to happen to my information except for it all (row A-O) to populate over in my “master”…..just as if I had simply pasted and copied the info from the sub-sheets to the master (which is what the person before me was doing). Please help!!! I have never worked with VBA Macro stuff and can’t read it…which doesn’t help I know. I’m humble enough to ask for you to explain this as elementary as possible. I’m just trying to work smarter not harder here. THANK YOU IN ADVANCE FOR YOUR HELP!!!!!

P.S. I have Excel 2010.

[TMS]

Sounds like you just need some VLOOKUPs.

Post a sample workbook for specific advice. That is, we don't know what the workbook, worksheets, data, formula ... or anything looks like.

Regards, TMS

[Leith Ross]

Hello A_TSC,

Welcome to the Forum!

I changed your thread title to reflect your question. This will help you get an answer more quickly when people know what you want.

[A_TSC]

There are no forumals in my sub-sheets just info and I need everything from the lines that I say are active to populate over to my master. Can Vlookups bring over the entire line (A-O)?

[A_TSC]

is there a way to upload my Excel workbook to this forum so that you can get a visual?

[TMS]

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[A_TSC]

Ok I uploaded it. My column A in all the sub-sheets are blank right now but once I am done entering everything will have an A for Active or X for Not Active.