Transfer data between files
I would like to trasfer a number from a cell in one file (worksheet) to
another and keep populatiing the next cell. I wanted to use a command button to tranfer the numbers. For example From: File ="POS 4-20-09", transfer cell = A1, Sheet = 1 (Lets say value = 100) To: File = Data Master, Cell = A1, Sheet = "sum" (cell A1 now has 100) Now the next day I hit the button From: File ="POS 4-21-09", transfer cell = A1, Sheet = 1 (Lets say value = 500) To: File = Data Master, Cell = A2(the next open cell), Sheet = "sum" (cell A2 now has 500) I will already have the days sheet open say "POS 4-21-09 so I just need to have it send that A1 value to "Data Maseter" and put it in the next open cell. I can even open that file as well if needed. Can someone help me? Thanks |
All times are GMT +1. The time now is 10:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com