Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking excel sheets
actually I'll explain my need with a below ex.
c.code c.name apr may june july aug sept oct nov uptomar total 1010 xxxx 10 20 30 40 20 30 60 40 250 2010 xxxx 40 30 15 70 60 45 12 15 xxx 3010 xxxx 25 35 45 26 82 15 15 15 xxx like that there are around 1500 customers list are there. if I need to calculate the period apr to aug customer wise I have change my entair excel sheet i.e "TOTAL" column changed up aug and copying the above. but I want when I'm giving the period into sheet1 the next sheet has to prepare according to criteria customer wise . My openion is by linking the sheet or writing a macro we can get the result I think. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking excel sheets
Deepak if you can elaborately explain what you need, I might be able to offer
you a solution. I do not understand what you trying to achieve. "deepak bsg" wrote: actually I'll explain my need with a below ex. c.code c.name apr may june july aug sept oct nov uptomar total 1010 xxxx 10 20 30 40 20 30 60 40 250 2010 xxxx 40 30 15 70 60 45 12 15 xxx 3010 xxxx 25 35 45 26 82 15 15 15 xxx like that there are around 1500 customers list are there. if I need to calculate the period apr to aug customer wise I have change my entair excel sheet i.e "TOTAL" column changed up aug and copying the above. but I want when I'm giving the period into sheet1 the next sheet has to prepare according to criteria customer wise . My openion is by linking the sheet or writing a macro we can get the result I think. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data entry in excel by linking to other word doc. or excel sheets | Excel Worksheet Functions | |||
Linking Sheets | Links and Linking in Excel | |||
Linking sheets | Excel Discussion (Misc queries) | |||
Linking sheets | Excel Discussion (Misc queries) | |||
Linking 2 Excel Sheets, Anticipating Lines. | Excel Worksheet Functions |