Zshan
New member
- Joined
- Apr 28, 2020
- Messages
- 31
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel10
Hi everyone,
I am kinda new here & begginer I am working on a code but I need a little help!
My sheet requires two columns BASEAMOUNT & DATE
DATA SHEET = JACK_1
OUTPUT SHEET = JAMOUNTCOMING
JACK_1 CONTAINS "DATE AS COLUMN C " & "BASEAMOUNT AS COLUMN E "
JAMOUNTCOMING CONTAINS "TOT AMOUNT AS COLUMN B " & "DATE AS COLUMN C"
When I insert row in JACK_1 I want "DATE & BASEAMOUNT" copied in "TOTAMOUNT & DATE" at the end of the cells automatically same like row in JACK_1 but instead its bieng inserted in second last cells and also its affecting other columns in JAMOUNTCOMING which is not good.
the code I am using is
in this code source for values is fine means getting last values of cell but inserting is problem & its also not good for other columns.
If anybody could help me it'll be great!
I am kinda new here & begginer I am working on a code but I need a little help!
My sheet requires two columns BASEAMOUNT & DATE
DATA SHEET = JACK_1
OUTPUT SHEET = JAMOUNTCOMING
JACK_1 CONTAINS "DATE AS COLUMN C " & "BASEAMOUNT AS COLUMN E "
JAMOUNTCOMING CONTAINS "TOT AMOUNT AS COLUMN B " & "DATE AS COLUMN C"
When I insert row in JACK_1 I want "DATE & BASEAMOUNT" copied in "TOTAMOUNT & DATE" at the end of the cells automatically same like row in JACK_1 but instead its bieng inserted in second last cells and also its affecting other columns in JAMOUNTCOMING which is not good.
the code I am using is
Code:
Sub JAMOUNTCOMING()
Worksheets("JACK_1").Range("E2").Offset(1, 0).End(xlDown).Copy
Worksheets("JAMOUNTCOMING").Range("B3").End(xlDown).Offset(1, 0).Insert
Worksheets("JACK_1").Range("C2").Offset(1, 0).End(xlDown).Copy
Worksheets("JAMOUNTCOMING").Range("C3").End(xlDown).Offset(1, 0).Insert
Application.CutCopyMode = False
End Sub
in this code source for values is fine means getting last values of cell but inserting is problem & its also not good for other columns.
If anybody could help me it'll be great!
Last edited by a moderator: