Data transfer from one sheet to another

I have a simple spreadsheet that imports data into Sheet1 and ranks it low to high with a major number category in column A and a sub category number in column B.  It then has a description in Column C.
I need a simple macro that looks at Column A, B and C in Sheet 1 and whenever that data changes, it updates column A and B in Sheet 2. The trick is that Column A in Sheet 2 is actually the combination of Columns A and B in Sheet 1.  The information in Sheet 1 Column C goes to Sheet 2 Column B.

That's it!

Much thanks in advance.   Sample Sheet attached.

Who is Participating?
viralypatelConnect With a Mentor Commented:
check the solution attached.
There is no need of a macro. Just drag the formula in the cols a and b in your target sheet all they way down till you want it. Sheet-to-Sheet-Data-Movement-Mac.xlsx
Bright01Author Commented:

Thanks for the quick response.  Here's the problem with that.  Actually 2 problems.  

1.) Sheet 2 actually has the ability to add new elements that can be "auto sorted" by a macro that is looking for updating on it.  For example, if the data has come in from Sheet 1, and you add a 1.22 at the end of the data on Sheet 2, it will automatically insert it into Sheet 2 between 1.2 and 1.3.


2.) You can change the data in Sheet 2; so if I use formulas, I'll constantly be overriding the formulas whenever I add a line of data.

This is why I wanted a macro behind the sheets.

Make sense?

Much thanks,

Bright01Author Commented:
Although the answer works, it is not ideal for the application I am trying to accomplish.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.