| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying values from one sheet to the same cell in another sheet
I'm sure this is a very simple theing to do but right now I just can't think
of a way to accomplish it. All I am looking to do is copy the value in cell A1 or A2 or B4 etc. in sheet1, into the corresponding cell, A1 or A2 or B4, in sheet2. Any help will be greatly appreciated. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying values from one sheet to the same cell in another sheet
in A1 on the second sheet, hit the equals sign, then click on the tab for the
1st sheet (at the bottom of the spreadsheet), then click on A1 on the first sheet If you copy down (Ctrl-D) to A2, A3, etc and copy across (Ctrl-R) to B1, B2, etc, the furmula will automattically adjust. "Ayo" wrote: I'm sure this is a very simple theing to do but right now I just can't think of a way to accomplish it. All I am looking to do is copy the value in cell A1 or A2 or B4 etc. in sheet1, into the corresponding cell, A1 or A2 or B4, in sheet2. Any help will be greatly appreciated. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying values from one sheet to the same cell in another shee
I was actually looking to do this in code. Any ideas?
"JasonP CCTM LV" wrote: in A1 on the second sheet, hit the equals sign, then click on the tab for the 1st sheet (at the bottom of the spreadsheet), then click on A1 on the first sheet If you copy down (Ctrl-D) to A2, A3, etc and copy across (Ctrl-R) to B1, B2, etc, the furmula will automattically adjust. "Ayo" wrote: I'm sure this is a very simple theing to do but right now I just can't think of a way to accomplish it. All I am looking to do is copy the value in cell A1 or A2 or B4 etc. in sheet1, into the corresponding cell, A1 or A2 or B4, in sheet2. Any help will be greatly appreciated. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying the repeated data of the previous sheet to the next sheet | Excel Discussion (Misc queries) | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
| Copying Specific Values From Sheet | Excel Discussion (Misc queries) | |||
| 2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
Linear Mode
