Macro with Information from Multiple Sheets

[jasonexcelhelp]

Hi,

I am writing a macro that organizes data, but also needs to be able to conditionally copy data from other sheets in a workbook.

I have a table with values...column A has the identifiers (strings of letters) and column N has comments related to the data in each row. So, for example, row 3 column A has the value "AAPL," and row 3 column N has the related value "sells electronic goods."


Now, I want to be able to copy column N based on the value of column A into other sheets using my macros. So, say I have another sheet in the workbook and row 6 column A has the value "AAPL," I want row 6 column N to have the related value from the previous sheet. Is it possible to do this?


Please let me know if this makes sense, and thank you so much for your help!

 

[patel45]

attach a link to your file, with current macro, current sheets and desired result

 

[hiker95]

jasonexcelhelp,

Welcome to the MrExcel forum.

What version of Excel are you using?

Can you post the raw data worksheet, and, post the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
Excel Jeanie
MrExcel HTML Maker
Or, when using Internet Explorer, just put borders around your data in Excel and copy those cells into your post.


If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data scrubbed/removed/changed
mark the workbook for sharing
and provide us with a link to your workbook.