If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Transfer Information
hi
i have 2 worksheets, when a new row of information is added to 1 worksheet, some of the details need to be transfered unto the next blank row of other. Is there any way i can do this ? -- Lois |
#2
|
|||
|
|||
Transfer Information
Hi Lois
Do you want to do it with code ? See http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Lois" wrote in message ... hi i have 2 worksheets, when a new row of information is added to 1 worksheet, some of the details need to be transfered unto the next blank row of other. Is there any way i can do this ? -- Lois |
#3
|
|||
|
|||
Transfer Information
Here is a general way to implement auto updates with any fancy macros.
Say data is entered in Sheet1 and in we want to auto transfer cols A & H to Sheet2. Say we want this in Sheet2 cols A & B: (Sheet1 col A = Sheet2 col A) (Sheet1 col H = Sheet2 col B) In Sheet2 A1 enter: =IF(Sheet1!A1="","",Sheet1!A1) and copy down In Sheet2 B1 enter: =IF(Sheet1!H1="","",Sheet1!H1) and copy down This as data is added to Sheet1, the proper info gets transferred to Sheet2. -- Gary''s Student - gsnu200848 "Lois" wrote: hi i have 2 worksheets, when a new row of information is added to 1 worksheet, some of the details need to be transfered unto the next blank row of other. Is there any way i can do this ? -- Lois |
#4
|
|||
|
|||
Transfer Information
Thanks, for the source range & dest sheet do i need to type in the full file
path or just the workbook names? -- Lois "Ron de Bruin" wrote: Hi Lois Do you want to do it with code ? See http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Lois" wrote in message ... hi i have 2 worksheets, when a new row of information is added to 1 worksheet, some of the details need to be transfered unto the next blank row of other. Is there any way i can do this ? -- Lois |
#5
|
|||
|
|||
Transfer Information
Hi Lois
If you want to copy to another workbook see this example "What if the Database sheet is in another workbook" -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Lois" wrote in message ... Thanks, for the source range & dest sheet do i need to type in the full file path or just the workbook names? -- Lois "Ron de Bruin" wrote: Hi Lois Do you want to do it with code ? See http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Lois" wrote in message ... hi i have 2 worksheets, when a new row of information is added to 1 worksheet, some of the details need to be transfered unto the next blank row of other. Is there any way i can do this ? -- Lois |
Thread Tools | |
Display Modes | |
|
|