Automatically copy data from one sheet to other sheets

[wilkisa]

Help!!

I have a sheet that contains the input data on the sheet called BIDS. The four other sheets in the book should have different parts of the input data placed into them and my customer wants it done automatically.

Sheet BIDS:
ColA..........ColB..........ColC..........ColD..........ColE..........ColF.........ColG
Name........ERI............Origin........Dest...........Mover.......Air Wt.......Ocean Wt
I M Goofy...R..............Here..........There.........ABC..........800..........1100
..................................................................XYZ..........850...........1200
Ye Hah.......E..............What..........When........ABC..........650...........900
..................................................................XYZ..........625...........850

I have used dots to separate my columns. I hope it comes thru okay. Also, there are many more columns of data but I didn't include them here.

What we need is to have the NAME, ERI, ORIGIN, DEST column data to copy to all four other sheets (named ABC, XYZ, ACTUAL, COMPARE) in the book. Then the data in ColF and ColG for ABC movers should automatically link to the ABC sheet; ditto for XYZ. Sheets ACTUAL and COMPARE will pull data from the unlisted columns.

My customer will be putting the the name, ERI, origin and destination on every other line on the BIDS sheet. On the other sheets, there will be no blank row separator. Also, sheets ABC, XYZ, ACTUAL, COMPARE will not have the MOVER column in them.

Is this possible?

 

[Eric van Uden]

I'm surprised none of the VBA-wizards have replied to your post.

My first inclination was to say: why don't you just put formulae in the target-cells that get the information in the source-cells?

Or M.I. Goofy now?

 

[wilkisa]

Thanks for the reply, Eric. Actually, I was hoping for a solution from someone by now.

Can anyone else help? PLEASE????