Can i Connect two sheet together
How can i connect two sheet together
for Example if i need to write function in sheet one that depends on some information in sheet two
is that possibe ??
are you talking about in Excel? IF you could give me a bit more detail, i can help
First thank you very much for your interest
i mean im doing a work sheet for book shop
in the first sheet i have the daily sales which i use every day
in the second sheet i have like table for the monthly sales
what i want to do is when i record the daily sales in sheet 1 ,, it goes automaticlly to the monthly sales in the second sheet ( by using functions )
is that possible ?
Or if im working in sheet 2 and im using the ( Sum function ) to calculate some date but these data exist in sheet 1 ?? is that possible ?
Thank You ..
yes that should be a problem. You can simply go into Sheet 1 and go into a cell and use = YOUR FORMULA OR Answer to sheet 2. This way, anytime you update Sheet 2, sheet 1 will automatically update with the number. Does this make sense?
Yes that exactly what i need
but i dont know how ??
if i go to sheet 1 and choose cell A ( for example ) and i want to write formula which is the sum of 4 or 3 cells but this sheet 2
will it work ?
cause if i write ( =sum B1:B6 )in one cell in sheet 1 this will calculate the cells in sheet 1 not 2 ,, Right ?
You got if. Go to the cell in sheet 1 that you want to display the calculation. Go to that cell and type in =(. Then go to sheet 2 and start clicking on the cells that you want to add c2+c3+c4) then hit enter. You'll be brought back to sheet 1 with the answer. Try this and let us know.
Thank You very much
it works perfectly
but without ()
i just typed = then clicked on the cell in the other sheet
it workd perfetly
thank you again for ur interest