have a tricky one... how do i go about coding a macro so that it can look at a column,lets say column F in this case, on a worksheet and figure out how many rows contain data, select all rows BUT the header row (row 1 in this case), select them for copy, and paste them to another spreadsheet in the xls file starting from row 2, pasting values only.
the way i would LIKE to do this function is to take column 1, determine its length, or how many rows contain data and where the first empty row kicks in, anchor that into a variable and use that variable to set the copy paste function for the remaining columns i run the function on.
why do i need this done? i'm makign a macro that can automatically build reports for me from raw data dumpted from the system.... and later columns in the spreadsheet have empty cells, so i want the function to process at a fixed length with all cells using column one as a guide for the copy/paste function.
make sense? i'd appreciate if somebody could give me a idea of what the code would look like.