Sorting and Moving Rows in Multiple "stencil " worksheets

M

may2

Hello, I hope that someone can help me with this problem. I have two
worksheets in the same Excel file; each worksheet has 3 columns as
shown:
Name Abbreviation Value in the first worksheet.
Name Abbreviation Comments in the second worksheet.
As I type in the first Worksheet the first two columns are directly
copied automatically into the second worksheet due to the formulas I
have placed in the second worksheet. However, if I alter the first
worksheet columns, then the comments do not follow correctly in the
second worksheet. The comments column will not stay with the correct
rows anymore in the second worksheet if I move the data around in the
first worksheet.
Can anyone offer advise?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move rows to another worksheet with vba 4
OFFSET LOOKUP function in VBA? 9
Shared Workbooks & Code 1
Problem sorting a range of columns using VBA 1
How do I sort worksheet without affecting formula values? 1
Worksheets and Events 5
Copy cells to different sheet if value found 1
Another 'Copy To The Next Available Row' Question 2

Top