paste as rows

Hi guys, Is there a VBA code that someone can help me with, What I am trying to achieve is insert a row of copied cells to another row that has a value of "here" A4 is the row I want to copy. So along Column B each cell has the formula ; =IF(C5=C4,"","HERE") And the value returns as HERE at...

From sheet 1 copy selected row then search sheet 2 For same, And if the first range matched then update Sheet 2. if no match then paste on next empty row sht1 row A16 THRU K16 SHT2 Find Match from sheet 1 in sheet 2 If A16 thru K16 match update these only, Leave L16 Alone, If no Match copy in...

I am struggling with my code- and will admit that I am a newbie to VBA. Yes- I have reviewed a ton of posts and dont seem to be able to fix my code. It seems that no one else has an answer to the multiple sheets question. :confused: I am trying to extract rows that meet a specific value...

Hi Any help with VBA on this would be appreciated.:confused: I have a workbook, z:\promotional and marketing\product performance\weekly data\cacs.xls which I download each week. Firstly, I need to Copy cells A2 : last active cell in column R I then need to Paste Values into z:\promotional and...

Hi First time post-er, excel newbie. I used Ron Bruin's VBA module to merge 732 workbooks into one worksheet. That worked great but each record (from each workbook) is spread over 38 rows. The data is all in the same columns (D, H, J and L), just spread out over 38 rows! What I need is a...

Hi there - I am trying to use VBA to take each of 15 tabs in my workbook, paste the data into a master sheet (as values and maintaining column widths) and then delete the original tabs after that I'm having trouble as I can't figure out how to use pastespecial in combination with End(xlUp), as...

I need some help with a macro. I created an event where a cell is changed and thus updates the table by filtering with the number that gets updated- this part works fine. The problem I'm having is that the macro I created is supposed to copy the filtered information and paste it into a new...

Hi Guys, I need a small help from you guys, I need to copy Paste Column A,B,C and D column into the end of the sheet with their headings. Can anyone help me out in that case? Thanks in Advance

Hi, I recently posted a query but it was more like a project. I am solving one by one. I have already sorted column A to C based on column A values. Now I need to copy and paste column A in Sheet2. But in Sheet2 I want each row should contain only 10 values, the remaining values should go into...