Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Needing Help with Data Transfer/Automatic Link
I've an Excel Spreadsheet with 6 columns, 1 column which has a question, 4 of
them I add figures to and these are totalled etc, and then there is 1 column which takes text/comments. I want to know if I can automatically extract the text column along with the corresponding columns to another page? -- angrob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Needing Help with Data Transfer/Automatic Link
When do you wish to transfer the data, on demand, once the cells of a
row are filled ? Do you want to delete the data from the source once it has been transfered ? Daniel I've an Excel Spreadsheet with 6 columns, 1 column which has a question, 4 of them I add figures to and these are totalled etc, and then there is 1 column which takes text/comments. I want to know if I can automatically extract the text column along with the corresponding columns to another page? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Needing Help with Data Transfer/Automatic Link
Hi angrob
Yes you can. Take a look at Advanced Filter. You should find plenty of help at http://www.contextures.com/xladvfilter01.html#ExtractWs -- Regards Roger Govier "angrob" wrote in message ... I've an Excel Spreadsheet with 6 columns, 1 column which has a question, 4 of them I add figures to and these are totalled etc, and then there is 1 column which takes text/comments. I want to know if I can automatically extract the text column along with the corresponding columns to another page? -- angrob |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Needing Help with Data Transfer/Automatic Link
hi
i want to transfer the data once the cells have been filled and No I don't want to delete data from source. -- angrob "Daniel.C" wrote: When do you wish to transfer the data, on demand, once the cells of a row are filled ? Do you want to delete the data from the source once it has been transfered ? Daniel I've an Excel Spreadsheet with 6 columns, 1 column which has a question, 4 of them I add figures to and these are totalled etc, and then there is 1 column which takes text/comments. I want to know if I can automatically extract the text column along with the corresponding columns to another page? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Needing Help with Data Transfer/Automatic Link
Look at the following file. It has 2 sheets. When you enter data in the
first 6 columns of "source" sheet, the row is transfered to the "Target" sheet. http://www.filedropper.com/angrob Here is the macro : Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column 6 Then Exit Sub If Application.CountA(Range(Cells(Target.Row, 1), Cells(Target.Row, 6))) = 6 Then With Sheets("Target") myRow = .[A65000].End(xlUp).Row + 1 Range(Cells(Target.Row, 1), Cells(Target.Row, 6)).Copy .Cells(myRow, 1).PasteSpecial xlPasteValues End With End If End Sub HTH Daniel hi i want to transfer the data once the cells have been filled and No I don't want to delete data from source. -- angrob "Daniel.C" wrote: When do you wish to transfer the data, on demand, once the cells of a row are filled ? Do you want to delete the data from the source once it has been transfered ? Daniel I've an Excel Spreadsheet with 6 columns, 1 column which has a question, 4 of them I add figures to and these are totalled etc, and then there is 1 column which takes text/comments. I want to know if I can automatically extract the text column along with the corresponding columns to another page? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Needing Help with Data Transfer/Automatic Link
when I follow the link it doesn't show me the file, what do I do here?
-- angrob "Daniel.C" wrote: Look at the following file. It has 2 sheets. When you enter data in the first 6 columns of "source" sheet, the row is transfered to the "Target" sheet. http://www.filedropper.com/angrob Here is the macro : Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column 6 Then Exit Sub If Application.CountA(Range(Cells(Target.Row, 1), Cells(Target.Row, 6))) = 6 Then With Sheets("Target") myRow = .[A65000].End(xlUp).Row + 1 Range(Cells(Target.Row, 1), Cells(Target.Row, 6)).Copy .Cells(myRow, 1).PasteSpecial xlPasteValues End With End If End Sub HTH Daniel hi i want to transfer the data once the cells have been filled and No I don't want to delete data from source. -- angrob "Daniel.C" wrote: When do you wish to transfer the data, on demand, once the cells of a row are filled ? Do you want to delete the data from the source once it has been transfered ? Daniel I've an Excel Spreadsheet with 6 columns, 1 column which has a question, 4 of them I add figures to and these are totalled etc, and then there is 1 column which takes text/comments. I want to know if I can automatically extract the text column along with the corresponding columns to another page? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatic data transfer | Excel Discussion (Misc queries) | |||
How to find a data in Sheet1,automatic transfer to Sheet2(Excel) | Excel Discussion (Misc queries) | |||
Automatic transfer of data from one worksheet to another | Excel Discussion (Misc queries) | |||
vb code - Automatic transfer of data from one sheet to another | Excel Worksheet Functions | |||
vb code - Automatic transfer of data from one sheet to another | Excel Worksheet Functions |