Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
export data between spreadsheets
Hello,
how do I setup an excel file that each time when I enter data in one spreadsheet it will export to another excel file in the same column of subsequent rows? Example: if each time data enter in one spreadsheet column A of row 1 it will export this data to another spreadsheet column B of row 1,2,3... and so on. Thanks. Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
export data between spreadsheets
Hi scott
See http://www.rondebruin.nl/copy1.htm See the last example on the page -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "scott" wrote in message ... Hello, how do I setup an excel file that each time when I enter data in one spreadsheet it will export to another excel file in the same column of subsequent rows? Example: if each time data enter in one spreadsheet column A of row 1 it will export this data to another spreadsheet column B of row 1,2,3... and so on. Thanks. Scott |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
export data between spreadsheets
What is your definition of "spreadsheet"?
Another workbook or another sheet within the same workbook? I will assume worksheet in same workbook since you did mention "file" In Sheet1 add this event code. Private Sub Worksheet_Change(ByVal Target As Excel.Range) On Error GoTo stoppit Application.EnableEvents = False If Target.Address = "$A$1" And Target.Value < "" Then With Sheets("Sheet2").Cells(Rows.Count, "B").End(xlUp) .Offset(1, 0).Value = Target.Value End With End If stoppit: Application.EnableEvents = True End Sub Right-click on Sheet1 tab and "View Code". Copy/paste the code into that sheet module. Note: Sheet2 B1 will remain blank or if you wish, add a title in B1 to start with. Gord Dibben MS Excel MVP On Fri, 28 May 2010 12:36:01 -0700, scott wrote: Hello, how do I setup an excel file that each time when I enter data in one spreadsheet it will export to another excel file in the same column of subsequent rows? Example: if each time data enter in one spreadsheet column A of row 1 it will export this data to another spreadsheet column B of row 1,2,3... and so on. Thanks. Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
export data between spreadsheets | Excel Worksheet Functions | |||
Export data from the same cell from multiple spreadsheets into a n | Excel Discussion (Misc queries) | |||
Import Data / Edit Data / Export Data in Excel | Excel Programming | |||
How do I combine data from various Excel spreadsheets into one Excel spreadsheets | Excel Programming | |||
import/export quattro pro spreadsheets | Excel Discussion (Misc queries) |