Dynamic range without 0 in VBA

[needvba]

Hi everyone

I need help with VBA. Thanks for your help in advance. I have summarized the topic below.

I have a data of 37 lines. I want to take this data into a table on another page, but I want the value 0 not to appear in the table when retrieving the data. The values in the data are dynamic. So it also needs to be dynamic in my table too. I finished everything but have no idea how to make my painting dynamic. I tried some codes in vba but non of them work for me. Can you help me please its really important to me

Best regards

BANKA ADI														ORAN

BANK MELLAT
TURKISH BANK A.Ş.
JP MORGAN CHASE BANK NATIONAL ASSOCIATION
ING BANK A.Ş.
FİBABANKA A.Ş.		94
TURKLAND BANK A.Ş.
ICBC TURKEY BANK A.Ş.
QNB FİNANSBANK A.Ş.

 

[needvba]

Hi everyone

I need help with VBA. Thanks for your help in advance. I have summarized the topic below.

I have a data of 37 lines. I want to take this data into a table on another page, but I want the value 0 not to appear in the table when retrieving the data. The values in the data are dynamic. So it also needs to be dynamic in my table too. I finished everything but have no idea how to make my painting dynamic. I tried some codes in vba but non of them work for me. Can you help me please its really important to me

Best regards

BANKA ADI														ORAN

BANK MELLAT
TURKISH BANK A.Ş.
JP MORGAN CHASE BANK NATIONAL ASSOCIATION
ING BANK A.Ş.
FİBABANKA A.Ş.		94
TURKLAND BANK A.Ş.
ICBC TURKEY BANK A.Ş.
QNB FİNANSBANK A.Ş.

CITIBANK A.Ş.	0
BANK MELLAT	0
TURKISH BANK A.Ş.	0
JP MORGAN CHASE BANK NATIONAL ASSOCIATION	0
ING BANK A.Ş.	0
FİBABANKA A.Ş.	94
TURKLAND BANK A.Ş.	0
ICBC TURKEY BANK A.Ş.	0
QNB FİNANSBANK A.Ş.	0
DEUTSCHE BANK A.Ş.	0