excel copy and paste

Hi guys, I'm trying to find a way to copy a range from and until a cell contains the specific text "Total". L1/2 are the header, so the data should begin copying at L3:Q for the blue background. However, I want to stop copying once it reaches "Total". I'm currently just being thrown errors and...

I have a sheet that has 4 tables. Let's say tables are A, B, C, and D. Table B has columns A-O, if column O has the value of W then copy that row (Column's A-N) and paste to the next available row of table D. Any help would be greatly appreciated.

I need help with some vba for Excel 2010. I have a workbook with two sheets: Detail and Tally. I've attached images of each sheet. Data is entered every day on the Details sheet. Column J is auto populated with the current date when a prodno is entered in column D and the week to which the...

Hello, I am trying to make my excel sheet copy an entire row of data to a new sheet if the column contains a certain criteria. Specifically: on the worksheets named: All results 1882-1900, All results 1900-1950, and All results 1950-2000 If Column F contains W then copy the whole row to a...

Hi guys I need to find a way to have a macro button to copy and paste form one cell and paste it into a table on the on second tab. on my first sheet I have column for our Customer Code Sheets("Data_Entry") B3 and one for QTY ("Data_Entry") C3 l like to copy and paste this to a table in a...