| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking cells again :-(
Suleman, thanks for trying but stil no go... maybe what you responded will
work and I just misunderstand what to do. I have a database in one worksheet that controls customer info, inventory and tracks sales by an invoice number. I am trying to create an invoice that is autmatically populated by the information from that worksheet. On the invoice (new worksheet) I would like to change a single value in multiple formulas automatically... Basically, I would just like to change the row number (in multiple cells) on the new worksheet... maybe I'm going about this all the wrong way -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
linking cells again :-(
If you want to change a single element simultaneously in multiple formulas,
just assign the same cell number to that element in each of those formulas, then vary the value of that cell........... Vaya con Dios, Chuck, CABGx3 "pegman" wrote: Suleman, thanks for trying but stil no go... maybe what you responded will work and I just misunderstand what to do. I have a database in one worksheet that controls customer info, inventory and tracks sales by an invoice number. I am trying to create an invoice that is autmatically populated by the information from that worksheet. On the invoice (new worksheet) I would like to change a single value in multiple formulas automatically... Basically, I would just like to change the row number (in multiple cells) on the new worksheet... maybe I'm going about this all the wrong way -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
linking cells again :-(
OK, that will probably work... I pulled up that annoyying little paper clip
guy that is always tapping on my screen and typed in 'assigning cell number to element'... no help there... this is driving me nuts -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! "CLR" wrote: If you want to change a single element simultaneously in multiple formulas, just assign the same cell number to that element in each of those formulas, then vary the value of that cell........... Vaya con Dios, Chuck, CABGx3 "pegman" wrote: Suleman, thanks for trying but stil no go... maybe what you responded will work and I just misunderstand what to do. I have a database in one worksheet that controls customer info, inventory and tracks sales by an invoice number. I am trying to create an invoice that is autmatically populated by the information from that worksheet. On the invoice (new worksheet) I would like to change a single value in multiple formulas automatically... Basically, I would just like to change the row number (in multiple cells) on the new worksheet... maybe I'm going about this all the wrong way -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
linking cells again :-(
The row number in a formula cannot be a variable, if that's what you are
trying to do. "CLR" wrote: If you want to change a single element simultaneously in multiple formulas, just assign the same cell number to that element in each of those formulas, then vary the value of that cell........... Vaya con Dios, Chuck, CABGx3 "pegman" wrote: Suleman, thanks for trying but stil no go... maybe what you responded will work and I just misunderstand what to do. I have a database in one worksheet that controls customer info, inventory and tracks sales by an invoice number. I am trying to create an invoice that is autmatically populated by the information from that worksheet. On the invoice (new worksheet) I would like to change a single value in multiple formulas automatically... Basically, I would just like to change the row number (in multiple cells) on the new worksheet... maybe I'm going about this all the wrong way -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
linking cells again :-(
This seems to work fine........
=SUM(B1:D1)+INDIRECT("A"&E1) Vaya con Dios, Chuck, CABGx3 "dlw" wrote: The row number in a formula cannot be a variable, if that's what you are trying to do. "CLR" wrote: If you want to change a single element simultaneously in multiple formulas, just assign the same cell number to that element in each of those formulas, then vary the value of that cell........... Vaya con Dios, Chuck, CABGx3 "pegman" wrote: Suleman, thanks for trying but stil no go... maybe what you responded will work and I just misunderstand what to do. I have a database in one worksheet that controls customer info, inventory and tracks sales by an invoice number. I am trying to create an invoice that is autmatically populated by the information from that worksheet. On the invoice (new worksheet) I would like to change a single value in multiple formulas automatically... Basically, I would just like to change the row number (in multiple cells) on the new worksheet... maybe I'm going about this all the wrong way -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
linking cells again :-(
I've been playing with this a little, I hate to just drop this because I not
a very bright guy and you guys are trying to help me figure this out... Thanks... I keep getting errors though... =COUNT(Sold!I16) is one of the formulas, all the formulas need to change the '16' is the variable -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! "CLR" wrote: This seems to work fine........ =SUM(B1:D1)+INDIRECT("A"&E1) Vaya con Dios, Chuck, CABGx3 "dlw" wrote: The row number in a formula cannot be a variable, if that's what you are trying to do. "CLR" wrote: If you want to change a single element simultaneously in multiple formulas, just assign the same cell number to that element in each of those formulas, then vary the value of that cell........... Vaya con Dios, Chuck, CABGx3 "pegman" wrote: Suleman, thanks for trying but stil no go... maybe what you responded will work and I just misunderstand what to do. I have a database in one worksheet that controls customer info, inventory and tracks sales by an invoice number. I am trying to create an invoice that is autmatically populated by the information from that worksheet. On the invoice (new worksheet) I would like to change a single value in multiple formulas automatically... Basically, I would just like to change the row number (in multiple cells) on the new worksheet... maybe I'm going about this all the wrong way -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
linking cells again :-(
Try this..........
=COUNT(INDIRECT("Sold!I"&D1)) Vaya con Dios, Chuck, CABGx3 "pegman" wrote: I've been playing with this a little, I hate to just drop this because I not a very bright guy and you guys are trying to help me figure this out... Thanks... I keep getting errors though... =COUNT(Sold!I16) is one of the formulas, all the formulas need to change the '16' is the variable -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! "CLR" wrote: This seems to work fine........ =SUM(B1:D1)+INDIRECT("A"&E1) Vaya con Dios, Chuck, CABGx3 "dlw" wrote: The row number in a formula cannot be a variable, if that's what you are trying to do. "CLR" wrote: If you want to change a single element simultaneously in multiple formulas, just assign the same cell number to that element in each of those formulas, then vary the value of that cell........... Vaya con Dios, Chuck, CABGx3 "pegman" wrote: Suleman, thanks for trying but stil no go... maybe what you responded will work and I just misunderstand what to do. I have a database in one worksheet that controls customer info, inventory and tracks sales by an invoice number. I am trying to create an invoice that is autmatically populated by the information from that worksheet. On the invoice (new worksheet) I would like to change a single value in multiple formulas automatically... Basically, I would just like to change the row number (in multiple cells) on the new worksheet... maybe I'm going about this all the wrong way -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
linking cells again :-(
HEHEHE... I'M A BLOODY GENIUS!!!
I typed in something like =COUNT(INDIRECT("Sold!I"&D1)) and it works great!!! Guess if I stay at it long enough I can figure anything out!!! -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! "CLR" wrote: Try this.......... Vaya con Dios, Chuck, CABGx3 "pegman" wrote: I've been playing with this a little, I hate to just drop this because I not a very bright guy and you guys are trying to help me figure this out... Thanks... I keep getting errors though... =COUNT(Sold!I16) is one of the formulas, all the formulas need to change the '16' is the variable -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! "CLR" wrote: This seems to work fine........ =SUM(B1:D1)+INDIRECT("A"&E1) Vaya con Dios, Chuck, CABGx3 "dlw" wrote: The row number in a formula cannot be a variable, if that's what you are trying to do. "CLR" wrote: If you want to change a single element simultaneously in multiple formulas, just assign the same cell number to that element in each of those formulas, then vary the value of that cell........... Vaya con Dios, Chuck, CABGx3 "pegman" wrote: Suleman, thanks for trying but stil no go... maybe what you responded will work and I just misunderstand what to do. I have a database in one worksheet that controls customer info, inventory and tracks sales by an invoice number. I am trying to create an invoice that is autmatically populated by the information from that worksheet. On the invoice (new worksheet) I would like to change a single value in multiple formulas automatically... Basically, I would just like to change the row number (in multiple cells) on the new worksheet... maybe I'm going about this all the wrong way -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking cells into empty cells in another worksheet | Excel Discussion (Misc queries) | |||
| Linking cells with a diffrent sheet with 2 cells | Excel Worksheet Functions | |||
| Linking a horizontal set of cells to a vertical sets of cells | Charts and Charting in Excel | |||
| Linking cells | Excel Worksheet Functions | |||
| linking cells | Excel Worksheet Functions | |||
Linear Mode
