-
Obtain text between words and populate to different cell in another sheet
Hi there,
Trying to write some VBA to populate a few cells from another sheet.
Sheet 1:
Sheet 2:
In Sheet 1, cell D2, the code should look for 'Application Name:' field on Sheet 2 (merged cell A4) and return 'Task Management' (merged cell F4).
In Sheet 1, cell E2, the code should look for 'System Name:' in merged cell A2 on Sheet 2 and return 'Sandbox'.
In Sheet 1, cell F2, the code should look for 'Version:' in merged cell A2 on Sheet 2 and return '6.4.00100.1056'.
In Sheet 1, cell G2, the code should look return '1/31/2019' in merged cell A3 on Sheet 2.
If possible, there are multiple sheets like Sheet 2 in the workbook, and need to loop to bring those values to Sheet 1. Any assistance is greatly appreciated.
-
Sorry...just realized the Sheet 1 and 2 images does not display. Here they are -
Sheet 1:
Sheet1.png
Sheet 2:
Sheet2.jpg
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules