write cell values to a closed file

D

Dave

Hi gang,
I am on Excel 2003

I have a problem I am trying to solve . I am trying to keep a log of
all invoices that are processed by the invoice clerks in a given
period. I would like to populate a spreadsheet M-log from the cell
values (H6,O6,P6,H7,H15 & O14 from " Invoice1". I would like this to
insertion to
occur when the " Invoice1" spreadsheet is closed .


The spreadsheet M-log will not be open at this time &, its path
would be c:\excel\m-log. I would like to insert the values into
"Sheet1" of M-log and into the cell range B8,B9,B10,B11,B12,B13


thanks,
 
D

Dave Peterson

Check your earlier post.
Hi gang,
I am on Excel 2003

I have a problem I am trying to solve . I am trying to keep a log of
all invoices that are processed by the invoice clerks in a given
period. I would like to populate a spreadsheet M-log from the cell
values (H6,O6,P6,H7,H15 & O14 from " Invoice1". I would like this to
insertion to
occur when the " Invoice1" spreadsheet is closed .

The spreadsheet M-log will not be open at this time &, its path
would be c:\excel\m-log. I would like to insert the values into
"Sheet1" of M-log and into the cell range B8,B9,B10,B11,B12,B13

thanks,
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Write to a closed excel spreadsheet 2
Retrieving a range of values from a closed file 6
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Arrays and scattered cell values or another way? 16
correcting #value! problem 4
Comparing a cell value with a range in a table and displaying a response 0
Log to a file everytime I open a spreadsheet 1
how to sort (by one field), copy (based on one field) to another tab,then clear data on original she 3

Top