Macro to lookup a sheet, number, then display in origonal sheet
 

Hi,

As you may have already guest I am new to the forum and Excel Macro's. I am using Excel 2003. I have a spreadsheet with 3 sheets (WILL HAVE 20).

All information is entered into the 'Data' sheet. The 'Data' sheet has 5 refrences (Ref, Text, Slave, Module, Bit)

Ref, Text, Module and Bit are repeated within each 'Slave' book dependant of which slave is listed in the 'Data' sheet.

What I want to do is dependant on what Slave, Module and Bit is selected in the 'Data' sheet, the information in 'Text', 'Module' and 'Ref' is automatically displayed in the relevant 'Slave' sheet from the 'Data' sheet.


Please see attached file.

Sorry if I have not made it clear, but hopefully you get the idea. This will save me copy and pasting the relevent 'text and ref' info from the 'Data' sheet to each and every 'Slave' sheet. 40 sheets with 135 bits of info!

Any help would be very much appreciated.

Thanks

Mark

Hi, Shall I asume that this is not possible or too difficult to do? A quick one word reply would be appreciated, or ideally a solution



thanks

I think MS Access would do this job.

Hi,

The problem I have with Access is no one in the department is using access, and think it will take too long to transfer the data over, plus the info would need to be transfered back to an excel format as before so as the software package we have can read it. I know Access can output this, but again in the short term not really an option.
Are the formulas difficult or the macro long?
Thanks again

Abbsy3