Need macro to fill data

**kishoremcp** · 10-01-2012, 08:27 AM

Hi, I have an excel which has three sheets.
I need a macro which should copy a range of cells from sheet "Data" to sheet "Report" as per my selection in sheet "Input"

In Sheet "Input" if the cell value is "Kishore" then it should copy J6 to J35 from sheet "Data" to sheet "Report" from B2 to B32
In Sheet "Input" if the cell value is "Krishna" then it should copy K6 to K35 from sheet "Data" to sheet "Report" from C2 to C32

Please help

Attaching the sample file.

**rvasquez** · 10-01-2012, 08:50 AM

Hello there,

Can you please explain to me why if "Kishore" is selected from the "Input" worksheet then you would copy column J?

Thanks!

**kishoremcp** · 10-01-2012, 11:37 AM

It is my requirement. Please help....

**rvasquez** · 10-01-2012, 11:42 AM

Hello there,

Sorry, I do understand that this is your requirement. If there is no explanation for why each section is grabbed then please explain each of your requirements.