empty column

This is my current attempt at copying data from one tab and pasting into a table on a different tab. I began modifying the code below. The text highlighted in yellow is where I need help. Essentially, here are the two scenarios: ONE- If F5 on the "Instructions" tabs = 1, then copy columns H:J...

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...

I AM STRUGGLING WITH GETTING THIS PIECE OF CODE TO WORK. i KEEP GETTING "APPLICATION DEFINED ERROR AND OBJECT DEFINED ERROR" AND CANT SEEM TO FIGURE OUT WHY. IT ALL LOOKS CORRECT TO ME. PLEASE HELP ME OUT Dim source As Worksheet Dim destination As Worksheet Dim emptyColumn As...

i would like to paste my manually copied columns to another sheet next to an empty column. and start paste on column E if not empty using a command button as trigger like if i manually copy column B from sheet1 and paste it to sheet2 column E if not empty.

i have a set of data that i want to copy and paste to the next empty column i have searched all over but cannot find anything that answer my query this is what i have so far and it doesnt even do columns it does rows ActiveSheet.Range("B6:C33").Copy Sheets(1).Cells(Rows.Count...