Related:
- Adding cells in excel from diff. sheets
- Google sheets right to left - Guide
- Excel mod apk for pc - Download - Spreadsheets
- How to copy data from one excel sheet to another - Guide
- Adding days to a date in excel - Guide
- How to open excel sheet in notepad ++ - Guide
1 response
Tweedledum
Posts
181
Registration date
Monday 19 January 2009
Status
Member
Last seen
2 April 2009
125
2 Feb 2009 à 11:00
2 Feb 2009 à 11:00
You could use a macro or function itd be something like
ActiveSheet.Range("G5").CurrentRegion.Select
Selection.Copy
Sheets("Sheet7").Select
ActiveSheet.Paste
Current range will select everything beside it so it might be closer to
ActiveSheet.Range("G5").Select
This line would select the sheet
Sheets("Sheet7").Select
The destination would be something similer to the first line although a little different. I'm no excel guru or anything but that will get you on the right path
ActiveSheet.Range("G5").CurrentRegion.Select
Selection.Copy
Sheets("Sheet7").Select
ActiveSheet.Paste
Current range will select everything beside it so it might be closer to
ActiveSheet.Range("G5").Select
This line would select the sheet
Sheets("Sheet7").Select
The destination would be something similer to the first line although a little different. I'm no excel guru or anything but that will get you on the right path
2 Feb 2009 à 11:24
2 Oct 2009 à 17:45
highlight the cell you want the 'total' to be in.
--->click on the 'E' sum button (usually on the 'home' ribbon, under the 'editing' section)
--->go to the other sheet, highlight the Cells you wish to Add/sum,
--->Press Enter.....your done. (do not navigate anywhere else before you press enter as this will change the formula)
Explanation:
=SUM(otherSheet!cellRange1:cellRange2)
Example formula:
=SUM(SheetTwo!D24:D26) this will add cells d24 through d26 on another sheet called: SheetTwo.
Example of adding cells from 2 different sheets:
=SUM(SheetTwo!D24)+(SheetThree!D10)
8 Oct 2014 à 07:59