basement_ron
New Member
- Joined
- Jun 20, 2011
- Messages
- 2
Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
I have a workbook with a sheet called "Statements". I would like to find each cell with a value in column A and I. When a value is found use that value to activate another open window that is named the same as the cell value. I would then copy and paste the corresponding required info to the "Statements" sheet, close the window and continue to find the next cell with value. I need to do this for about 100 workbooks and if there isn't a workbook open then I want it to continue to the next cell. My programming is not up to this level yet, so I'm not sure if this is doable and how much coding would need to be done. I'm ok with the copy and past parts, but the finding each cell and activating the window is a problem for me. I would appreciate any help in getting started on the code if it can be done.<o></o>
<o></o>
Thanks,<o></o>
Ron<o></o>
fficeffice" /><o></o><o
></o>I have a workbook with a sheet called "Statements". I would like to find each cell with a value in column A and I. When a value is found use that value to activate another open window that is named the same as the cell value. I would then copy and paste the corresponding required info to the "Statements" sheet, close the window and continue to find the next cell with value. I need to do this for about 100 workbooks and if there isn't a workbook open then I want it to continue to the next cell. My programming is not up to this level yet, so I'm not sure if this is doable and how much coding would need to be done. I'm ok with the copy and past parts, but the finding each cell and activating the window is a problem for me. I would appreciate any help in getting started on the code if it can be done.<o
></o><o
></o>Thanks,<o
></o>Ron<o
></o>
