copy & paste macro

Good morning all, I've hit a bit of a road block with some reporting and database automation and I was hoping one of you could help! I have a databse of product that I'm using to call certain data. For ease of reading the report I'd like to insert rows that have the summary of the product, then...

I have a workbook with multiple sheets which are exactly the same(User Input templates). Each sheet has about 100 cells of information which I am copying by looping through the worksheets and then pasting into a summary file called "Master". I would like to loop through all the worksheets copy...

I have been working through VBA code that copies the first worksheet in a folder to another workbook. The code copies the data correctly but upon saving I get certain cells with errors (#Ref) this is due some of the copied cells having formula. I would like the copied data to retain the...

New to VBA, using Excel 2013. I am trying to select a rage columns and rows to copy and paste and transpose into a new sheet. I have searched for anything close and have not been successful. I am including my raw data then a generic walkthrough of what I need the Macro to do. My issue is, I need...

I am trying to copy data from a closed workbook from a specific sheet and from a specific range and paste it into my active workbook but into a specific sheet starting at cell B7. I have the below code however it is only returning zeros. can anyone point me in the right direction? I will be...

Hi guys, I'm having trouble running a VBA. Seems fairly simple but not too sure how to do this. What I'm doing is going through every cell within a column. If a cell contains "N/A", then the vba will copy the cell above and paste it into that specific "N/A" cell. The VBA should loop until there...

Hi Mr.excelsiors, I have 3 workbooks with the same table that users need to fill with their own information. I would like to centralize all answers in a different workbook (master workbook) that already exists. So the idea is as follows: User 1 opens "workbook_user1" and fills the information...

I have a list that consists of names of files in a folder. In the table there are 2 other columns that have "Yes" and "No" conditions. Lets assume I have ABC_00 file in A2 and conditions are in B and C columns. Then B2 is "Yes" and C2 is "No" lets say. I need a VBA code that even one of the...

I am getting a Run-time error '1004':Application-defined or object-defined error in copy/paste section of my code and I can't figure out why it is doing that. The last thing I tried was to add Cstr to the ranges. This macro is pulling information from one sheet and putting it to another, the...

Hi. I get an IE generated report once a week. I want to copy cells A4:E4 to the last value in those columns from this workbook (report.xls), from worksheet (report) and paste them into Table1 of the active workbook. What I have tried so far always overwrites the Table and ends up converting...

Hello I'm trying to copy data from all the workbooks in a folder into a summary workbook. Basically it needs to look through all the workbooks in the file and from each workbook get the following data: The data input should start from Row 5, and then move downward. <colgroup><col...

Hi all, having some trouble with something that is likely very uncomplicated, but due to my very, very rookie status when it comes to VBA, it's complicated. I have a template being used for data import into a website tool developed for my team at work. It needs to be imported as a CSV file. I...

I have 2000+ workbooks (A) in a folder (each having only one worksheet with data structured the same across all the workbooks). I also have another workbook (B) in a separate folder with: The first worksheet structured the same as the 2000+ single-worksheet workbooks and 4 additional...

Hi all, I am new to VBA and I tried to write a macro to append data from Book 1 (active workbook where will have the macro) which is updated daily, to Book 2 ( close Archiving excel) which is only used for queries. Book 1 and Book 2 have the same column headers in row 1, with dates in column A...

Hi All I am trying to transfer data from sheet 1 "report" in cells I11:V11 (fixed) and the date for this report is located in K1 to the corresponding date on sheet "Daily Data Input" to cells C:P (rows constantly change) where the dates are located in B:B (the entire year is listed here). The...

So I have a report that is emailed to me daily, I have a macro enabled to save the files automatically to a location on my desktop (C:\Users\rwebber\Desktop\TSA Hourly Report) and the file saves as SSC Hourly Update "the date it was emailed". I would like to place a button on my page called...

Not even sure excel is able to do what I want this way but I'm trying to take data that's in Column D on sheet "RemoveDup" and copy it to Row 2 on sheet "Final" using a VBA. If the VBA finds a blank cell in the RemoveDup Column the VBA ends. So the below code "works" in the sense that it moves...

Hoping someone can help with some good VBA code. Situation: I have three columns: This Period. Last Period Cumulative. This Period Cumulative. I have set up my spreadsheet so that the user will only need to input "This Period" values. However, I want the spreadsheet to automatically update the...

hi everyone, I'm not the best in marcos and I've been searching for a solution to this for a while. So what I'm doing is copying a table in a worksheet into another worksheet and transposing it. Some worksheets that contain the original tables can have a lot of tables which is way a marco...

Hello, As the title suggests I'm trying to copy a range of filtered cells. The source has a lot more than 5 rows but of these filtered cells I'm only trying to copy the first 5. This is the code I've been using so far: Sub Top5() Dim CopyRange As Range Sheets(5).Range("B3").AutoFilter...