Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving data to another file - help needed
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving data to another file - help needed
Folder = "C:\temp\
FName = "Master.xls" Set Mstbk = workbooks.open(filename:=folder & FName) with Mstbk.sheets("Sum") LastRow = .Range("A" & Rows.Count).end(xlup).row NewRow = LastRow + 1 thisworkbook.ActiveSheet.Range("A1").Copy _ Destination:=.Range("A" & NewRow) end with Mstbk.close savechanges:=true "JTWarthogs" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
Deleting Rows With Non-Needed Data between Needed Data | Excel Worksheet Functions | |||
Moving data from one excel file to another | New Users to Excel | |||
Moving file locations | Links and Linking in Excel | |||
moving file from excel to word | Excel Discussion (Misc queries) |