Prev: Need Help Remove Duplicate Values In Array ?
Next: Save as PDF not working on a domained Windows 7/Vista box
From: scott on 28 May 2010 15:36
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
From: Ron de Bruin on 28 May 2010 16:01
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" <scott(a)discussions.microsoft.com> wrote in message news:08B9D78E-DE95-494C-B0BE-8EA1A50B9F0B(a)microsoft.com...
> 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
From: Gord Dibben on 28 May 2010 16:41
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 <scott(a)discussions.microsoft.com>
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

 | 
Pages: 1
Prev: Need Help Remove Duplicate Values In Array ?
Next: Save as PDF not working on a domained Windows 7/Vista box