How to copy cell value on Sheet 1 to a location in a text in another cell on Sheet 2
Requirement:
The value in cell B2 on Sheet 1 is: 45,678.
The user needs that information to automatically copy to a specific location in a text (text is located in cell A9 on sheet 2).
The salary range for this group and level is $[INSERT Minimum salary] to $[INSERT Maximum salary] per year. Your salary on appointment to this position will be $[INSERT Employee’s salary] per year. Your salary will be paid on a bi-weekly arrears pay cycle.
Solution:
A9 on Sheet2:
="The salary range for this group and level is $"&Sheet1!B2&" to $[INSERT Maximum salary] per year. Your salary on appointment to this position will be $[INSERT Employee’s salary] per year. Your salary will be paid on a bi-weekly arrears pay cycle."
Obtained from the OzGrid Help Forum.
Solution provided by Mumps.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to use a macro to run through sheet in excel and put double quotes around values |
| How to create a button to run formula on every sheet in workbook |
| How to populate image control from pics in the sheet |
| How to compare 2 columns in different worksheets and overwrite existing record if a match found |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
