Still need help

C

casadegeorge

Is there a way to save information in certain cells and place them into
other cells in another excel file by using macros or any other
functions?
 
C

Chip Pearson

It isn't clear exactly what you want to do, but you can get the value of one
cell in another with a function like

=Sheet1!A1

This will return the value of A1 on Sheet1 to the cell containing the
formula. If you want VBA code, try something like

Worksheets(2).Range("B2").Value = Worksheets(1).Range("A1").Value

If you need more help, post back with more details about what you are trying
to do.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]
 
C

casadegeorge

Chip,

This is what I want to do:(and I've attached two files that I'm working
on)

I have a basic Excel file for logging my PO's. I don't want to type
the information in the log everytime I place a PO. Is there a way to
shortcut this.

The Div, Type, and # are not important.

I will post a copy of the PO following this post.

File Attached: http://www.exceltip.com/forum/attachment.php?postid=315140 (p.o. log.xls)
 
Top