macro - copy/paste

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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!
  10. 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...
  11. D

    VBA macro to paste value of row above if columns to the right contain a value

    Hi All, I am new to macros and need some help. I have a generated file from Salesforce that populates fields into excel. I need to take this data set and uploaded it into another data base. However, the data set isn't complete. Current output file: https://screencast.com/t/CmFmtI2EWS Notice...
  12. 1

    Copy & Looping VBA code

    Hi, I have a workbook with other 100 sheets. Each sheet is identical; consists of 2 columns with the 2nd column to be copied and transposed into a mastersheet. I have created the macro to copy & transpose but cannot get the loop or repeat instruction correct. From reading many threads and other...
  13. Q

    Macro to find cell address and copy data to that cell

    I have to copy cells from a report spreadsheet into a master and where they go is determined by three different identifiers; DOCNBR, STNDDOCNBR and ACRN. So, I used CELL,"address",INDEX,MATCH to find the cell address where the information should go in the master. Then I used this macro to copy...
  14. S

    VBA Macro to copy and concatenate some columns from some rows of one worksheet to a different workbook

    Hello experts :cool: ... I'm a developer but have no experience with macros in excel and hoping someone here can save me some time. I need to create a button on one worksheet that will : - create a new workbook ... call it 'c:\sheets\Newbook.xls' ... (or open an existing one and empty it out)...
  15. G

    VBA - Copy values from a table in a worksheet to the last line of an existing sheet in another workbook

    Hi All, I have been able to find the following which works however instead of a worksheet in the same work book I'm wanting to copy the values the end of an existing worksheet in a different workbook. What i have so far is.... Sub Approved() Sheets("Timesheet 1st -...
  16. A

    Copy a range and paste in another column to the last row of data

    Hi I want copy a data range in column G starting with cell reference G2 to the last row, the last row of the data goes to say 1000 rows and I want to paste the copied range in column J starting with cell reference J2. now my question is if next time the number of rows increases the code will...
  17. G

    Didn't work my macro to copy&paste only as formulas by default... can you give it a quick check?

    Hi expert! I need your help to check this macro I found to copy and paste without formatting. I tried it but it made a complete mess... <code class="vb keyword" style="white-space: nowrap; padding: 0px !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier...
  18. W

    How to merge or combine lots of excel documents?

    Is there any way to merge/combine data from multiple unsaved excel documents so its neatly in one document? Essentially I have lots of excel tabs open (all unsaved) and want to take columns A1-A20 and B1-B20 of all excels and place into one main document going downwards. SO rather than have...
  19. M

    How do I copy one macro to apply to multiple rows???

    I need to create a macro so that when I click on a cell in any row on sheet 1, that cell and all others in the row transfer over into a table in sheet 2. i have started a macro to apply to row 2, how do I copy it so that it applies to any row I click on but still pastes in the same format in...
  20. M

    How to apply one macro to multiple rows?

    I need to apply one macro so that any row in sheet 1 will transfer into a table on sheet 2. This is the macro so far which applies to row 2: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top