Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter out rows of information in a list via VBA | Excel Discussion (Misc queries) | |||
information filter | Excel Discussion (Misc queries) | |||
Copy filter Information | Excel Discussion (Misc queries) | |||
filter and keep same information. | Excel Worksheet Functions | |||
Filter specific information and format | Excel Programming |