Macro to overwrite data on another cell

Hi all,

I'm fairly new to VBA. I have project for my intern company. I want to overwrite data on another sheet, when I update the data on sheet 1 as an example. I have 17 other individual sheets.on the first sheet contains all my data, exp A-Z. I want to use a filter on sheet 1, let's say for 'A' and overwrite the existing data I have on sheet 2, which contains only data A. After that I go back to sheet 1, and use the filter to get only data B. And then to overwrite the existing data I have on sheet 3 . Etc etc. Thanks.

.
Here is a portion of the needed code :

Please Login or Register  to view this content.

hi logit, thanks for the code! i was wondering if it was possible to just overwrite the data, and not create a new table? I have hundreds of data on each sheet nad itll be quite confusing to look at if a new table is generated

.
Try this :

it is possible to sort it based on column 1 and 2 together?

.
As an example for you, I used the MACRO RECORDER. It is very useful when you are not certain what code to write as it will write the code for you.
It would be a good practice for you to look into it more and experiment.

This is the macro the RECORDER created :

Please Login or Register  to view this content.

This macro is "called" at the very beginning of the code located in MODULE 1 and the macro itself is located at the bottom of MODULE 1.

Oh you used macro recording. But then how did you manage to record you creating a new table consisting of data from individual columns? i cant seem time figure how you did that using recording. thanks man

.
Creating the new table was done via borrowed code from others on the FORUM and internet as well as gained knowledge.
Others have stated GOOGLE IS YOUR FRIEND .... very aptly put.

Cheers