Macro code, cell Data to pick from TAB name

[kishore k]

hi, I need a macro code where specific column has to pick from TAB name.

For Ex: excel sheet tab name "PRIME J654".

Data in Column M in same sheet as " J654- GOODS INTAKE"

1.Now, if I change the name of TAB to "PRIME J655", Then data in column M has to pick the last four characters "J655- SALE OF GOODS" (Sale of Goods to be entered manually)
2.Though the four characters pick from tab name to Column M, it should allow me to edit manually the data after J655- "SALE OF GOODS"
3.The data in column M has to be blank if there is no data in Column C. This column is for account code
4.I need to apply the macro to multiple tabs, with running tab names & numbers.like "Prime J655", "Sales J656", "Purchases J657" etc.,

Please help..

Regards,
kishore

 

[kishore k]

Hi, can someone help me with this macro.. please.

 

[kishore k]

can anyone help me with this..