Hii

[TVSHOWLISTER]

HI i am new here my name is Christy, I joined this site because i am having trouble with a particular VBA code

I want to take information from cells in work sheet2 and put it into work sheet1 last row which already has 1865 rows full of information

The Range from sheet1 is B1-B9, (which is a mostly a Static array so i use the copy feature here for the text entered)

I want to paste these cells into Sheet 1 B-J In the last row

I can provide pictures (i have 3) if you like to explain it better, i didnt really know the rules on pictures for noobs here lol

BTW Column A, uses an IF formula for ID field


EDIT:
BTW i want to use a Macro button for this

Its for listing/rating TV Shows im watching, i just want to make the process easier

 

[MARK858]

First of all I didn't ask any questions about column A anyway...
The code can't be overwriting anything in Sheet1 as it pastes to Sheet2.
If your description in your last post is correct all you should have to do is reverse the sheet names in the code.

 

[TVSHOWLISTER]

Its working now anyway thanks

 

[MARK858]

You're welcome.