Excel Cut and Paste Macros

[sb05r6]

I have a set of Data that I pull from Access and export to Excel. Each day is a new set of Data. The columns are "Manger" "Date" "Week" "LaborHours" "OperationsComplete."

My task is to auto filter on each manager, there are 25 of them. Copy all of the information from that day and Paste it into each Manager's Personal Workbook; they then add their own information to the data I have presented them.

They are then to manually input "CompleteTime" "QualityRemarks" "EmployeeName".

Each day I append another set of Data under the already added data from previous days, without tampering with prior data.

I have tried a macros that cuts and paste, but the macros always pastes in cell a1 and overlaps the previous days' data.

I have also tried a macros that that pastes to the last cell of the worksheet, then deleting blank cells in between, this was also a failure.

I am using Macros recorder, I have no idea how to write VBA.

Could anyone please help me with this problem? Thank You.

[jkelly228]

Hi sb05r6,

From your description it sounds like you need to find the last row of data and append the new data below that. If that is the case then the below code is what I use to take care of that. Let me know if this works of if I have misunderstood your request.

Kelly

Please Login or Register  to view this content.