Macro manipulating cells on other workbooks, help needed!

[Gallahan]

Hello,

I currently use this script:

Please Login or Register  to view this content.

What it does, is read a couple of cells for a text and a number and then adjusts the selected cells by said number and adds the text to a comment on all of the selected cells (works with a single or multiple selected cells)

What i need this script to do is: write the same comment and modify the cells value on another workbook, on the same coordinates, but one cell below.

I have been working on this for a couple of days now, but i just cant find a working solution, since my knowledge of VBA is so limited.

Any help will be greatly appreciated!

[walruseggman]

Would look something like:

Please Login or Register  to view this content.

[Gallahan]

Thank you very much walruseggman. I used your solution and it works great.

But now, i noticed that a couple of workbooks that I overlooked have the line that needs to be edited on another row. The column still stays the same as the selection in the original workbook, but the row number is different.

I found that the row on which i would need to edit the selected cells always starts with a cell that has the same word on all workbooks. Is there a way to make the script find a word "ExampleWord" and set the row for the cells which would be edited by my script?

[walruseggman]

Would the column remain the same as rCell's column?

[Gallahan]

Well yes. This macro is used like this:

A user selects a couple of variables from dropdown menus and highlights the cells he wants to modify. Then the macro cycles through the selected cells and increses their value by Num as well as adds a comment. Then, on another workbook the same must happen on the row which starts with "exampleword".

On workbooks that have the needed to edit cells on a different row the selection column would stay the same. Only the row differs and the needed row always has the same word in a cell that is somewhere in column A. The word is unique in every workbook and there is no chance of it being duplicated, so a simple method to find the word and use its row for the rCell would be sensible. I just fail to figure out how to achieve this on my own.

TLDR - Yes.

[walruseggman]

Please Login or Register  to view this content.