I am trying in vain to figure this out.
I have multiple workbooks. One is a list (WB #1). The list is generated from data in other workbooks. I'm trying to get the list to auto-populate after data in a cell is entered in the other WBs. If you enter data in column H in WB #2, I want to use VBA to open WB #1 add the value from column H to WB #1, then save and close WB #1. I also want to add the same code to WB #3 and 4 etc. to do the same task.
This gives me multiple problems.
From what I gather, any code that opens or closes a workbook should? must? be in either the This workbook area or in a module. If I put the code in either of these places, I can't use sheet specific code. It also seems I can't use code to open a file from sheet specific locations. I can get parts of my code to work separately but combining the two parts is where I'm stuck.
I am sorry if I am being vague with the information I am giving you. I just want to be pointed in the right direction. I am trying hard to learn this. and I want to try and do it on my own before someone writes the entire code for me.
Thanks,
Jim
I have multiple workbooks. One is a list (WB #1). The list is generated from data in other workbooks. I'm trying to get the list to auto-populate after data in a cell is entered in the other WBs. If you enter data in column H in WB #2, I want to use VBA to open WB #1 add the value from column H to WB #1, then save and close WB #1. I also want to add the same code to WB #3 and 4 etc. to do the same task.
This gives me multiple problems.
From what I gather, any code that opens or closes a workbook should? must? be in either the This workbook area or in a module. If I put the code in either of these places, I can't use sheet specific code. It also seems I can't use code to open a file from sheet specific locations. I can get parts of my code to work separately but combining the two parts is where I'm stuck.
I am sorry if I am being vague with the information I am giving you. I just want to be pointed in the right direction. I am trying hard to learn this. and I want to try and do it on my own before someone writes the entire code for me.
Thanks,
Jim