| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look up information on one worksheet and transfer to another | Excel Discussion (Misc queries) | |||
| Transfer information | Setting up and Configuration of Excel | |||
| how do I transfer information from one sheet to another? | Excel Discussion (Misc queries) | |||
| How do I transfer formulas but not the information? | Excel Worksheet Functions | |||
| How do I transfer information from Colums to Rows? | Excel Discussion (Misc queries) | |||
Linear Mode
