Khalid NGO
Excel Ninja
Hello guys, good day.
Need help in copying data from Database file (Sales sheet column A to M) to another file named CC-KHI-S1, base on cell N1 value say CC-KHI-S1.
Explaining a bit further, what I want is macro to look in CC-KHI-S1 file cell N1, and match it with all the rows found in Database file Sales Sheet column M, copy all matching records column A to M to the file CC-KHI-S1.
If we change the cell N1 value to say CC-KHI-S2, then macro should copy only those rows.
Both worksheets are in same folder, actual file is heavy therefore i have attached simplified versions but the structure is same.
Any or all help is appreciated.
Regards,
Need help in copying data from Database file (Sales sheet column A to M) to another file named CC-KHI-S1, base on cell N1 value say CC-KHI-S1.
Explaining a bit further, what I want is macro to look in CC-KHI-S1 file cell N1, and match it with all the rows found in Database file Sales Sheet column M, copy all matching records column A to M to the file CC-KHI-S1.
If we change the cell N1 value to say CC-KHI-S2, then macro should copy only those rows.
Both worksheets are in same folder, actual file is heavy therefore i have attached simplified versions but the structure is same.
Any or all help is appreciated.
Regards,
