I am looking for some assistance creating a custom cut and paste macro for Excel.
I currently have a spreadsheet with columns ranging "A:BZ: I need to examine two fields in each row, begining on Row 3. The spreadsheet being examined is 'VIEWFMT" and will always have this title.
I need to look at each PART NUMBER in Column "BF" and the corresponding QUANTITY in Column "BM". Using row 3 as an example, If the quantity in "BM3" is greater then 0, then I want to copy "BF3" and "BM3" to a New workbook (Sheet1), "A1:B1". I want to loop through the list of 600 lines until complete.
I apprecaite any help that is available.