| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find last row
I am working with a data set that constantly changes length there are
more rows each week. I am writing a macro that inserts a new column then combines the text from two columns into the new column but I only want the equation in rows which already have data. If I paste into all rows it won't sort properly. For example original data: Fname lname John smith Jane Smith John Doe Jane Doe Modified data Name fname lname Johnsmith John Smith JaneSmith Jane Smith JohnDoe John Doe JaneDoe Jane Doe What macro lines do I need if I want to paste the equation in column Name only if there is data in column Fname. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find last row
See this page for a few examples
http://www.rondebruin.nl/last.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "KurtB" wrote in message ups.com... I am working with a data set that constantly changes length there are more rows each week. I am writing a macro that inserts a new column then combines the text from two columns into the new column but I only want the equation in rows which already have data. If I paste into all rows it won't sort properly. For example original data: Fname lname John smith Jane Smith John Doe Jane Doe Modified data Name fname lname Johnsmith John Smith JaneSmith Jane Smith JohnDoe John Doe JaneDoe Jane Doe What macro lines do I need if I want to paste the equation in column Name only if there is data in column Fname. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| 'find' somtimes can't find numbers. I folowd the 'help' instructi. | Excel Worksheet Functions | |||
| How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
| find replace cursor default to find box | Excel Discussion (Misc queries) | |||
Hybrid Mode
