If I Input Data(=one Of Sheetsname) In Column D (eg. Row1=a,row2=b,row3=b,row4=c,row5=a,row6=d....) Then How Can Input This Data With Selceted Column(eg. Column A,b,f) In The Same Row To Blanked Row WITHIN COLUMM A,D,F In The Same Named Sheet.
THANKS IN ADVANCE
Worksheet Change Event
-
-
-
Re: Worksheet Change Event
Sorry, I don't understand what you are trying to do.... can you be more specific in your explanation ?
-
Re: Worksheet Change Event
NICE TO MEET YOU.
Thanks -
Re: Worksheet Change Event
So for row 1 of Sheet1, I am assuming by the value in cell A1 that you want to put something on Sheet2. But what value and where on Sheet2 is it supposed to go?
-
Re: Worksheet Change Event
Actually Column D Is Data Same As Sheet Names And When Input Data Then How Selected Column In Same Row Can Transfer To Blank Row In The Same Named Sheet Eg. Column A,b,d.
-
-
Re: Worksheet Change Event
Can you post an example of what it will look like after the macro runs? And highlight the new information?
-
Re: Worksheet Change Event
If I Have A Table A:l And I Inputted Data Low 200,then Column A,f,g In Low 200 Will Be Placed Blanked Low To The Same Named Sheet In The Column A,c,d.
-
Re: Worksheet Change Event
Here Is Attched File,not Macro.
-
Re: Worksheet Change Event
I think changes I made in the attached file does what you want.
-
Re: Worksheet Change Event
NICE TO MEET YOU AGAIN.
Sheet Is Updated And I Make Work Sheet Change Event In Sheet1.
Thanks For Your Help. This Attatched Files Have A Problem, Advise Me. -
-
Re: Worksheet Change Event
What is the problem? I added a new line and it added it on the appropriate sheet.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!