| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste
How do you
1. A value on sheet 1 in Row "A" (Row A2:A156) needs to be matched to a "=" value on sheet 2 in Row "A" (Row A2:A6), and then Cells (J & x : AH & x) need to be copied from sheet 2 and pasted in sheet 1 row of the value matched Cells (J & x : AH & x) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy and Paste
Look at the vlookup worksheet function
-- Regards, Tom Ogilvy "Rozb" wrote in message ... How do you: 1. A value on sheet 1 in Row "A" (Row A2:A156) needs to be matched to a "=" value on sheet 2 in Row "A" (Row A2:A6), and then Cells (J & x : AH & x) need to be copied from sheet 2 and pasted in sheet 1 row of the value matched Cells (J & x : AH & x) . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy and Paste
Thanks Tom ----- Tom Ogilvy wrote: ---- Look at the vlookup worksheet functio -- Regards Tom Ogilv "Rozb" wrote in messag .. How do you 1. A value on sheet 1 in Row "A" (Row A2:A156) needs to be matched to "=" value on sheet 2 in Row "A" (Row A2:A6), and then Cells (J & x : AH x) need to be copied from sheet 2 and pasted in sheet 1 row of the valu matched Cells (J & x : AH & x) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Copy, paste without file name referenced after paste | Excel Discussion (Misc queries) | |||
| Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
Linear Mode
