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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula between sheets.
There may be many ways this can be done but I do it using VLOOKUP
I will reorder the main sheet so that Col Q comes before Col H, N and O I will take a new sheet then I will copy Col Q in the main sheet to Col A of the new sheet Then I will lable Col B-D with labels in H, N and O columns in the main sheet Then in B-D enter VLOOKUP so that I get values from the main sheet Once you have that you can sort Col A and still get the correct values from the main sheet in other columns. "AB Lighting" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula between sheets.
If you need help with VLOOKUP visit
http://www.experiglot.com/2007/12/27...-excel-tricks/ "Sheeloo" wrote: There may be many ways this can be done but I do it using VLOOKUP I will reorder the main sheet so that Col Q comes before Col H, N and O I will take a new sheet then I will copy Col Q in the main sheet to Col A of the new sheet Then I will lable Col B-D with labels in H, N and O columns in the main sheet Then in B-D enter VLOOKUP so that I get values from the main sheet Once you have that you can sort Col A and still get the correct values from the main sheet in other columns. "AB Lighting" wrote: 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 |
Reply |
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) |