I have a section of one page that has 3 columns of info pulled from multiple cells in other places on the page, not all the rows in this section have anything in them. I want to pull all the lines with something in them to a second page of the same workbook with all the info in staying in line. Is this a VBA job or just some formulas and a ctrl+shft+enter job?
IE: my info is in AF13:AH1291 (Named "CS_INFO") on page "ADD MTRX", and if the row has information in it, I want to copy it to sheet "CS INFO" starting at location J21 without any of the blank rows.
After it's put on the "CS INFO" sheet, I need to output it to a tab delimited rich text file. (I think this I can do with VBA and a button when I need the output). I had figured out how to do this 10 years ago at a different company. Now I've forgotten again. If you can help, I would appreciate it, if you can explain it to me, I'd be very grateful!
Thanks,
Rob
IE: my info is in AF13:AH1291 (Named "CS_INFO") on page "ADD MTRX", and if the row has information in it, I want to copy it to sheet "CS INFO" starting at location J21 without any of the blank rows.
After it's put on the "CS INFO" sheet, I need to output it to a tab delimited rich text file. (I think this I can do with VBA and a button when I need the output). I had figured out how to do this 10 years ago at a different company. Now I've forgotten again. If you can help, I would appreciate it, if you can explain it to me, I'd be very grateful!
Thanks,
Rob