I have a file Auto Generated that has 2 columns - First labels and Second values
Then I have a Master Reference sheet which contains references to cells from different sheets in a sub folder that contains values needed for the Second column in my Auto Generated file.
Can I macro be prepared that could auto populate the values in the Auto Generated file?
Here is a link for sample files/ sub folder
https://www.dropbox.com/sh/z9nxll0wy04e2g8/AAAPMmhmOU_VRQNcpoLOiCyha?dl=0
So, if Row B has a reference in the Master Reference (in my example files, it is subfolder\a.xlsx > Sheet 2 > B3), then Column B for Row B in the Auto Generated file should get the value (35 in this example) from the referenced cell.
Thank you.
Then I have a Master Reference sheet which contains references to cells from different sheets in a sub folder that contains values needed for the Second column in my Auto Generated file.
Can I macro be prepared that could auto populate the values in the Auto Generated file?
Here is a link for sample files/ sub folder
https://www.dropbox.com/sh/z9nxll0wy04e2g8/AAAPMmhmOU_VRQNcpoLOiCyha?dl=0
So, if Row B has a reference in the Master Reference (in my example files, it is subfolder\a.xlsx > Sheet 2 > B3), then Column B for Row B in the Auto Generated file should get the value (35 in this example) from the referenced cell.
Thank you.
