In excel, what's the code for below macro?The macro has to open another sheet(sheet 2) and copy the value of a cell from it,close the sheet 2 and paste the value in 1st sheet?
by 
kalyan
ANSWERS: 3
-
You don't need a macro - you just insert the sheet / column /row reference where you want it to appear.
-
Sub Macro1() Sheets("Sheet2").Select Range("C4").Select Selection.Copy Sheets("Sheet1").Select Range("C4").Select ActiveSheet.Paste End Sub Although it would be easier to go to the Tools... Macro... Record New Macro menu and go through the actions.
-
This only requires a formula: Let's say you want your value on Sheet2, cell A10 to appear at C4 in Sheet1. Then at C4, the formula is: =Sheet2!A10 You get the same result by entering an "=" sign at C4 and then using the mouse to select the worksheet and cell you want. You don't have to remember how to type in worksheet names (with single quote marks if a space appears in the name), or qualify with Workbook (file) names for open workbooks. Just point and click the cell, and the formula is written for you. Not a macro-worthy task.
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC