Excel to Excel Automation

L

lbargers

Could someone please explain the best process for taking data that has
been typed into certain cells in spreadsheet and sending this
information to another spreadsheet, in a different location.. Is this
possible thorough VBA.

Thanks for any advice..

Larry Bargers
 
S

swatsp0p

You are really better off using the destination to pull the info from
the original sheet. Excel is not built to 'send' info.

A simple formula such as:

='C:\Documents and Settings\My Documents\[Book4.xls]Sheet1'!$A$99

in your desired destination will _pull_ data from the listed sheet into
your new sheet. When the original is updated, the new sheet will update
as well.

HTH

Bruce
 
L

lbargers

Thanks for your response! That makes sense to pull it in that way. Does
it work the same for pulling in a range of values, or for checking if a
cerain box contains a 'No' value. For instance, lets say I wanted to
plug in a column of values, where one cell in that column contains text
= 'No'. Would this require running a do while loop in VBA?
 
L

L. Howard Kittle

Hi Larry,

Sheets("Sheet1").Range("A1").Copy _
Sheets("Sheet2").Range("B1")

Embellish the range as needed.

HTH
Regards,
Howard
 
D

Dave Peterson

You can use formulas in different cells to pull from various cells in the
original workbook (one cell pulls one cell (usually)).

And if you have linked cells that are assigned to those boxes, you can pull the
value from the linked cell, too. There is no formula that can pull directly
from a checkbox--even in the same workbook.
 
B

Bill Ridgeway

As someone has already commented you will have to pull data. It can't be
pushed.

There is a slight danger in having data in different spreadsheets. If data
in the origin cell is moved it will not be seen and you will get some funny
results. It is better, if at all possible, for the origin data and target
data to be in different worksheets in the same spreadsheet -if just to keep
everything together. Whether or not this can be done it is better to define
the name of the cell of origin. In this way it will be found wherever it
is. To do this highlight the cell of origin and click on
<Insert><Name><Define> enter a short name and click on <OK>

Regards.

Bill Ridgeway
Computer Solutions
 
Top