macro - copy/paste

  1. S

    Excel macro - open files - copy data - rename worksheet close files

    Hi there I hope someone can help with a small macro. The macro is to: 1. Look inside a specified folder at all csv files 2. Look at column G of the csv file which contains a date and time in this format 28/02/2018 08:31:10 and take the date from this the second row and then create a...
  2. U

    Open CSV File and Copy the Data on Other sheet

    Hi Guys, Here's a snap of my codes but it automatically paste the CSV file data on the data sheet. I was wondering if you could help me find the codes for GetOpenFile whereas the path file directory will open. After I paste the address, the macro will open the CSV file and paste everything on...
  3. M

    VBA-Macro Copy & Value Paste all non hidden Sheets data

    Hello Everyone, I am looking for a VBA-Macro help . I already complete the macro by using macro recorder. But every time, I need to change that code when the sheet name was changed. Please, anyone kindly help. Here is description of my problem : 1. I have a excel macro enabled file which has...
  4. U

    VBA Code Query

    Hi All, Ive recorded the following macro which does the function I wanted. I know that excel adds a lot of useless lines when you do this and since im trying to learn VBA, everytime I code something I try to learn and understand the code. So basically all it does is go to a specific tab and...
  5. M

    Inherited code - VBA to copy multiple sheets from workbooks on Sharepoint

    Hi I was hoping someone could help me please. I have been asked by my bosses to complete a macro started by someone else as I'm 'a bit IT'. I was a COBOL programmer in a previous life and that was 7 year ago, so have no idea about VBA code! Apologies if my questions are very basic. I would...
  6. P

    how to Copy data from one worksheet to another worksheet..Data should be copied on new rows every time

    Hi, Please help me in this problem. I have my data in worksheet 1 with Row headers..Like Name, City, Assignment,Date. Now worksheet 1 is having list of 100 members in Column1 and they will be assigned 2-3 type of assignment on daily basis. Assignment will be entered on Column 2..Date will will...
  7. K

    Macro - Copy cormulas & range based on value

    Hi guys, im trying to create a macro that can copy formulas in one column (cells: A10:A20) and based on a value in another cell (Cell: A1) the macro should paste the formulas the same number of columns (cells B10:G20) as the value is in Cell: A1 . Lets say the value is 4 (January to April)...
  8. D

    Pasting to a location specified within an active cell using VBA?

    Hi Guys, I am attempting to finish off a project for the team and wondering if VBA can achieve an unusual task. Goal: to copy the contents of cell (M3) in worksheet 2 into clipboard; thereafter, to paste the clipboard contents into a location in worksheet 1 i.e., into a cell which is specified...
  9. M

    macro for special copy / paste

    Hello and I need some help with defining a macro to do the following. My excel file has 2 register; "export" and "archive". At the end of each month I want to copy each line entry from register "export" that has a date stamp within that month and paste it into the register "archive" below the...
  10. T

    Macro Partial Cell Copy and Paste

    I've looked all over, but I can't find a solution for my problem. When recording a macro, how do you copy text from one cell, and append/paste it after the existing text in another cell. Before: <tbody> 4600 PE 4606 PB2 4610 PEM </tbody> After: <tbody> 4600 4600 PE 4606...
  11. T

    Help pasting cell values, not formulas...also how to sort merged cells, if possible

    Long time lurker, first time poster, I created a form on "Sheet 1" that utilizes a VLOOKUP function to fill specific cells. This is my current code: Sub CopyIngredients() Sheets("Sheet 1").Select Range("B18:R36").Select Selection.Copy Sheets("Sheet 2").Select Range("B1").Select...
  12. C

    split cells & copy across rows - what's wrong with my vba?

    Hi All! First up, new poster, and VBA isn't my best programming language. So, apologies if I've stuffed up something stupid -- I'm learning :laugh: Now, I've got a database full of rows of different cases, and I'm trying to split the cases so that there is only one "citing judge" per row. Each...
  13. R

    Excel macro : to comment history with date stamp

    Thanks in advance for your help. I am looking for a macro/function that does below: Column 1 : Has comments that I add in each day Column 2 : Maintain the history of all comments form the past When I add a comment in Column 1 , And when I press a button or automatically when I go away from...
  14. C

    Create new WS & copy column to new row in another WS with macro

    Thanks for stopping by, First off, I am new to VBA so I feel like what I am trying to accomplish is probably way over my head. Also, I have searched for a solution to this but can not find exactly what I need. I have a workbook that has an overview (Monthly) worksheet with value headers in...
  15. V

    Macro to move data from one tab to another

    Hello again! This forum helped me a few months ago with this macro to move data from one sheet ("Raw Data TY" & "Raw Data LY") to another ("Discount", "Group", Corporate", etc). The macro has been working well until I added the "Group" sheet. What I need to happen is the data that is in the...
  16. C

    VBA Pasting/looping

    I have a vba code to get info from multiple workbooks then paste them consecutively in one worksheet. I want the macro to paste to cell A1 everytime i run the macro, after clearing contents of the previous time i ran it of course. But instead it pastes to the last cell used from the last time i...
  17. S

    Macro to Copy Info and Paste to another tab and then delete afterwards from original tab

    Hello, So I am building a sheet that is tracking inventory within totes at work. There is two macros that I need help on. So a little info before I get into the need of macros, I have a macro currently built that keeps a running list of items that is in the tote and when you push a button it...
  18. S

    Trying to get macro to copy and paste from sheet 1 to sheet 2 and delete contents from sheet 1

    Hello, I am still a beginner to macros and learn quickly by reading forums on other's experiences with running macros. So let me explain what I am trying to do and I believe I am failing miserably. I am wanting to get the macro to copy the date from sheet 1 and paste it is cell A1 on sheet two...
  19. J

    VBA to copy current sheet (template) and make one sheet for each day of the month

    Hi, The title says it all. I want to use a macro to copy the current sheet(template) to a new sheet complete with the values I've put on the sheet, and the name of the sheet to be renamed to the current date. There is previous threads but not what I need. Thanks!
  20. N

    Find and Replacing Old Account with New Account

    Good morning, I know this has been answered a number of times already, but I don’t know enough VBA to interpret the code and manipulate it to meet my specific needs. Basically, I need to search column A for old account numbers (listed in column C), and replace the old account numbers with new...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top