Transferring Information
Ihave a spreadsheet which is comparing the information on the spreadsheet to
another spreadsheet via an Array Formula, if the information can not be found I am going to put No in a column. What i would like to be able to is to transfer all the informatoon over 6 columns against all the items showing No to another spreadsheet without sorting and to ttransfer the information on the other sheet in the next available line, Can this be done |
Transferring Information
Yes it can be done, but you need to write a macro to do it!
"Freddo" wrote: Ihave a spreadsheet which is comparing the information on the spreadsheet to another spreadsheet via an Array Formula, if the information can not be found I am going to put No in a column. What i would like to be able to is to transfer all the informatoon over 6 columns against all the items showing No to another spreadsheet without sorting and to ttransfer the information on the other sheet in the next available line, Can this be done |
All times are GMT +1. The time now is 01:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com