adding a formula vba

[JeremyGraham95]

I am working on an inventory spreadsheet and have multiple things that i have working. but the one thing i seem to be struggling with is that i have a sheet "RECORDS" which keeps track of how many of each item i have for the date the inventory is checked which is every other week). what i am trying to do is take the last 2 columns in the RECORDS sheet and subtract them from each other and paste that value in my new sheet "TRENDS" on the first empty column in this sheet. so i want a3-b3 to be put in the new sheet in the third row and so on all the way down to the 128th row. could anyone please help me. It would be greatly appreciated and i am needing this done by 01/25/2016. Thanks to anyone and everyone that attempts t help me out!!!

 

[WarPigl3t]

Do you want the code to create a new sheet for you and call it TRENDS? If so then the first empty column would be A and you didn't have to say "paste on first empty column". But since you did say it, I'd have to assume that you don't want the code to create a new sheet and that this sheet already exists. In which case when you said "new sheet", I would have to assume that it is not a new sheet that the code creates, but rather just a new sheet to you. A new sheet that you created for the purpose of this forum in other words. In that case you shouldn't say new sheet because those are key words about how people understand your post. So there are two ways to look at your post as I just described. Both ways require completely different code. So please refine your post so we all know what you mean.

 

[JeremyGraham95]

I already have a sheet called "TRENDS" and i want to post the results of that formula in the first empty column in the TRENDS sheet. the sheet already exists and i want this code to just keep track of how much of an item is being used.