Copy Data from Other Sheet

[sambit]

Dear Sir,
please help to resolve the following issue. please find the example file.

Case-1

Sheet1 :- The Original Data in this sheet

Sheet2 : - In this sheet we can see the data which is copy to Sheet1

Sheet3 : - Sheet1 is looks like after copy of data from Sheet2


Case-2

Sheet4 : - May be the Original Data Look in this in this sheet

Sheet5 : - In this sheet we can see the data which is copy to Sheet4

Sheet6 :- Sheet4 is looks like after copy of data from Sheet5

 

[sambit]

Dear Sir,
please find example file.

 

[Marc L]

Hi !

You can try easy VLOOKUP worksheet function …​

 

[Hareesh_KLD]

Hi For Case 1
Check the attached sheet

 

[sambit]

Hareesh_KLD Sir,
A lot of Thanks.

I would like to request you, please resolve the issue of case-2.

 

[Hareesh_KLD]

Hi Sambit

check the attached sheet for case2

 

[sambit]

Hareesh_KLD Sir,
A lot of thanks.
if some changes in sheet-2, I mean some row delete or add some data it will not update in sheet1.

 

[sambit]

Hareesh_KLD Sir,
waiting for your reply..........................

 

[Hareesh_KLD]

Busy, by tomorrow will try

 

[Hareesh_KLD]

Hi Sambit,

Pls check attached sheet, may be it will work

 

[sambit]

Hareesh_KLD Sir,
it will not work.

Sheet-1 data always remain same. If we want to add some data in Sheet-1 it must copy from sheet-2. Sheet-2 is knows as format or you may say it is working sheet.

After data copy from sheet-2 to sheet-1. We will delete the data in sheet-2 manually.

Then after we add some data in sheet2 and it will be copy by sheet-1 through command button.

After data copy from sheet-2 to sheet-1. We will delete the data in sheet-2 manually.

The above process going on………………………

 

[Hareesh_KLD]

Hi Sambit, what i understood is after copying data from sheet 2 to sheet 1, u r deleting data in sheet 2 and again adding some other data in sheet 2 in the same format and you press command button it has to add in sheet 1 along with old data

From my side it is only giving error when challan no less than D6 value, other than it is working fin

 

[sambit]

Hareesh_KLD Sir,
pl find example file.

 

[Hareesh_KLD]

Sambit,
Check attached sheet, for data check sheet 3

 

[sambit]

Hareesh_KLD Sir,
Many many thanks for your valuable solution.

I have observed some error.
pls find attached error file.

 

[Hareesh_KLD]

Sambit,

Check attach document

 

[sambit]

Hareesh_KLD Sir,
Thanks for your support.
Qty should not be repetition.

pls find attached file.

 

[Hareesh_KLD]

Sambit,

check the attached document

 

[sambit]

Hareesh_KLD Sir,
Thank you very much for resolve the issue.

if some changes required in future, I will raise the issue later on.

Thanks for the Continuous support.