Using formulas to filter information
Hi
Our company uses a very large spreadsheet when putting an order on the system most of this spreadsheet is not actually used so sorting through it to find out what stock is actually required is a bit of a nightmare. I have not really used excel to much of a degree but I would think that it is possible to right some sort of program to run on these spreadsheets that will look at say the D column carry out an IF statement to say IF D1=0 goto D2 if not copy C1 and D1 to another spreadsheet this way producing a smaller spreadsheet which details what is actually required. I know this must be possible but have no real idea how to go about doing it Please can someone help Regards Anthony |
Using formulas to filter information
Hi Anthony,
Consider using the AutoFilter or Advanced Filter features. If you are not familiar with these features, Debra Dalgleish has excellent tutorials at: http://www.contextures.com/xlautofilter01.html and http://www.contextures.com/xladvfilter01.html --- Regards, Norman "Anthony" wrote in message om... Hi Our company uses a very large spreadsheet when putting an order on the system most of this spreadsheet is not actually used so sorting through it to find out what stock is actually required is a bit of a nightmare. I have not really used excel to much of a degree but I would think that it is possible to right some sort of program to run on these spreadsheets that will look at say the D column carry out an IF statement to say IF D1=0 goto D2 if not copy C1 and D1 to another spreadsheet this way producing a smaller spreadsheet which details what is actually required. I know this must be possible but have no real idea how to go about doing it Please can someone help Regards Anthony |
All times are GMT +1. The time now is 02:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com