Hi to All,
Am just newbie in this forum. I seek assistance on creating a vba code that will enable me to copy certain range of data from sheet 1 to sheet 2. I would humbly appreciate to give me a vba code. I can understand a little bit of codes and understand modifying it. hope you can help!!!
Source Worksheet - 'Legend'
Target Worksheet - ' Summary'
Source Worksheet Content:
A1 B1
Item code Site Codes
01 USA
02 Canada
03 Russia
My objective is that I will create a command button that will quickly copy the contents in B1 in source sheet and automatically paste in target worksheet in a certain cell range.
In event that additional site codes will be added/deleted, i would just click the command button and will update the target worksheet.
Hoping for your kind assistance regarding this matter
Thank you
Glen
Am just newbie in this forum. I seek assistance on creating a vba code that will enable me to copy certain range of data from sheet 1 to sheet 2. I would humbly appreciate to give me a vba code. I can understand a little bit of codes and understand modifying it. hope you can help!!!
Source Worksheet - 'Legend'
Target Worksheet - ' Summary'
Source Worksheet Content:
A1 B1
Item code Site Codes
01 USA
02 Canada
03 Russia
My objective is that I will create a command button that will quickly copy the contents in B1 in source sheet and automatically paste in target worksheet in a certain cell range.
In event that additional site codes will be added/deleted, i would just click the command button and will update the target worksheet.
Hoping for your kind assistance regarding this matter
Thank you
Glen