Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula between sheets.
I am trying to find an easy way to take a full spreadsheet and using
different sheets write a formula to take certain inflormation into a new sheet a re sort it into different orders. eg. I have colums of data in this case the colums are bassed on electrical calculatios, weights. and other relevent information. Then each row is a seperate piece of equipment that has had the information entered. I now want to create a new sheet, in this I want to take the Information from colomn Q then H , N and O from the first sheet I want to re sort this information In lowest to highest from column Q with extra formula eg totals added on the end. I need it to be able to carry the details from the original sheet so If I were to change the No. in row Q in the first sheet then it will automatically move all the data in that row in this new sheet. Can anyone please give me some guidline of how to acheive this. What sort of formula do I need to write to keep this all to tally. I would really appreciate any help Cheers Andy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula across multiple sheets | Excel Worksheet Functions | |||
Formula from various sheets | Excel Discussion (Misc queries) | |||
Create a formula between sheets | Excel Discussion (Misc queries) | |||
Help! Formula between the sheets | Excel Worksheet Functions | |||
Referencing Sheets in a Formula | Excel Discussion (Misc queries) |