Still need help

  • Thread starter Thread starter casadegeorge
  • Start date Start date
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?
 
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 (e-mail address removed)
 
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)
 
Back
Top