Moving mulple columns, guru needed...

  • Thread starter Thread starter raymond m.
  • Start date Start date
R

raymond m.

Ok, I am not sure if this is possible in excel, but a friend asked me if I
could help him with
a problem, so here it goes:

Ok, Imagine a Excel spreadsheet file (A) with about a dozen columns filled
with information, now
the majority of the information in (A) is gotten from a different spread
sheet (B) created by somebody else
in a different state.


Now A would have already other existing info from other B transfers from
different dates, so A would be added
onto and B's are always created new from scratch each day, for that day
only. A is basically a running total for every day, and B
is one for only a single day's worth of data.

So right now, the way it's done is that by my friend copying the selected
columns from B into A, the selected column
data is exactly the same in both A and B, with some extra columns in A which
are not transfered from B, and in B
there are some that are not trafered to A.

Now these are two different docs files, we are not talking about two
different TABS sheets in a single doc.

The QUESTION:

Does Excel have some type of an automated way to transfer the columns from B
and into A. And if So, where do
I look, what do I look for, please give some pointers.
 
Hi

Excel is srictly "pull" technology. Which means that if you want cell Y to
contain something based on cell X, then the only way is to have a formula in
Y that pulls the information from X to itself.

So what you want does not exist. But it can be built. Tell your friend to
record a macro while performing the copy-paste routine and you're almost
there.

HTH. Best wishes Harald
 
So what you want does not exist. But it can be built. Tell your friend to
record a macro while performing the copy-paste routine and you're almost
there.
Click to expand...

Aah. The mythical friend :-)
 
Sans a macro...........If you have both Workbooks open at the same time,
then you can right-click on the sheet tab in Workbook B and then select
"Move or Copy..." and then follow the menu to copy the sheet over to
Workbook A........then you can delete the columns you don't want......
Now you have all the B data you want in A......then you can move it to
whatever sheet in A that you want......

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top