Vb code to copy data from one sheet to anothe

[Closed]
Report
-
Posts
2811
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 27, 2021
-
Hello,

My problem is similar to first one. I was able to solve with the solution provided by helper. thanks helper. But, if column Q contains blank cells in between then what will be the code.

I need to copy data from sheet2 and sheet3 to shheet4 based on the input selected in sheet1. So for e.g., if i select "Time" in sheet1 dropdown box , the rows that contain "Time" in sheet 2 and sheet 3 should be copied to sheet4.

thanx

1 reply

Posts
2811
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 27, 2021
484
Hi Nandy,

No idea to which problem you are refering to, couldn't find another post from you.

Anyway, which cell contains the dropdown list on sheet1?
Which column on sheet 2 and 3 contains items from the dropdownlist?

Best regards,
Trowa