Hello,
I am new to vba and macros and would like to ask your help to understand if what I'm trying to achieve is feasible using these tools.
The task is quite simple, I'm trying to automatically fill a pre-formatted datasheet in Excel (DS1) for an asset, with the data contained in a second Excel sheet (DS2) that collects data for several assets in a list form.
I need the program to do the following:
1. Find the Asset name in DS2 as specified by the user
2. Select the cell below the title which will contain a tag such as "Temperature"
3. This becomes my first variable X1
4. The program then has to select and copy the content in the cell to the right (i.e. 30 degrees) and this becomes my new variable X2
5. The program now has to search for X1 in the sheets of DS1
6. Once located it has to paste X2 in the cell to the right of the found X1.
7. Once this is done the program should go back to DS2 and the found asset name and select 2 cells down and repeat the steps 3-6 and so on (Loop)
Could you please let me know if this is doable and if you foresee any issues with the logic presented above? I would also like to ask if you could point me in the right direction in terms of code libraries/training material/existing threads to solve my task.
I hope this is not too much of a silly question,
Thank you in advance
Bookmarks