Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Addition Copy
Example sheet 1
a1 to a1000 each has a different number: sheet 2 cell a1 add sheet 1 a1 to a100 cell a2 add sheet 1 a101 to 200 Is there a way to copy formula into cell a3 without editing it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Addition Copy
one way:
Sheet2: A1: =SUM(OFFSET(Sheet1!A$1,(ROW()-1)*100,0,100,1)) Copy down as necessary. In article , Joey wrote: Example sheet 1 a1 to a1000 each has a different number: sheet 2 cell a1 add sheet 1 a1 to a100 cell a2 add sheet 1 a101 to 200 Is there a way to copy formula into cell a3 without editing it. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Addition Copy
Put this in A2 and copy down:
=SUM(OFFSET(Sheet1!$A$1,100*(ROW()-1),0,100,1)) Joey wrote: Example sheet 1 a1 to a1000 each has a different number: sheet 2 cell a1 add sheet 1 a1 to a100 cell a2 add sheet 1 a101 to 200 Is there a way to copy formula into cell a3 without editing it. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Addition Copy
Hi, Thanks for help, however, i did not clearly post my problem
going to cell a3 sheet 2 need to copy formula making it additional 100 rows 201 to 300 can this be done Thanks Joe "Dave Peterson" wrote: Put this in A2 and copy down: =SUM(OFFSET(Sheet1!$A$1,100*(ROW()-1),0,100,1)) Joey wrote: Example sheet 1 a1 to a1000 each has a different number: sheet 2 cell a1 add sheet 1 a1 to a100 cell a2 add sheet 1 a101 to 200 Is there a way to copy formula into cell a3 without editing it. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Addition Copy
I had a typo:
Put this in A1 and copy down: =SUM(OFFSET(Sheet1!$A$1,100*(ROW()-1),0,100,1)) But try it, then post back with your results. Joey wrote: Hi, Thanks for help, however, i did not clearly post my problem going to cell a3 sheet 2 need to copy formula making it additional 100 rows 201 to 300 can this be done Thanks Joe "Dave Peterson" wrote: Put this in A2 and copy down: =SUM(OFFSET(Sheet1!$A$1,100*(ROW()-1),0,100,1)) Joey wrote: Example sheet 1 a1 to a1000 each has a different number: sheet 2 cell a1 add sheet 1 a1 to a100 cell a2 add sheet 1 a101 to 200 Is there a way to copy formula into cell a3 without editing it. -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Addition Copy
Ps. The typo was "put this in A2". It should be A1. The formula didn't
change. Dave Peterson wrote: I had a typo: Put this in A1 and copy down: =SUM(OFFSET(Sheet1!$A$1,100*(ROW()-1),0,100,1)) But try it, then post back with your results. Joey wrote: Hi, Thanks for help, however, i did not clearly post my problem going to cell a3 sheet 2 need to copy formula making it additional 100 rows 201 to 300 can this be done Thanks Joe "Dave Peterson" wrote: Put this in A2 and copy down: =SUM(OFFSET(Sheet1!$A$1,100*(ROW()-1),0,100,1)) Joey wrote: Example sheet 1 a1 to a1000 each has a different number: sheet 2 cell a1 add sheet 1 a1 to a100 cell a2 add sheet 1 a101 to 200 Is there a way to copy formula into cell a3 without editing it. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Addition Copy
HI , Thank you. This is exactly what was needed.
Joe "Dave Peterson" wrote: Ps. The typo was "put this in A2". It should be A1. The formula didn't change. Dave Peterson wrote: I had a typo: Put this in A1 and copy down: =SUM(OFFSET(Sheet1!$A$1,100*(ROW()-1),0,100,1)) But try it, then post back with your results. Joey wrote: Hi, Thanks for help, however, i did not clearly post my problem going to cell a3 sheet 2 need to copy formula making it additional 100 rows 201 to 300 can this be done Thanks Joe "Dave Peterson" wrote: Put this in A2 and copy down: =SUM(OFFSET(Sheet1!$A$1,100*(ROW()-1),0,100,1)) Joey wrote: Example sheet 1 a1 to a1000 each has a different number: sheet 2 cell a1 add sheet 1 a1 to a100 cell a2 add sheet 1 a101 to 200 Is there a way to copy formula into cell a3 without editing it. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Copy a relative reference formula from one sheet to another. | Excel Discussion (Misc queries) | |||
copy & paste formula between spreadsheets - not working | Excel Worksheet Functions | |||
copy paste formula to skip rows | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions |