macro - append rows

  1. M

    Use a Macro to format report to reduce number of lines used

    Hi, I have quite a large report where a lot of the data is represented in rows and duplicated. The report has 17 columns and ~5100 rows. Within these columns only a couple has data that is different to the row above. I want to be able to reduce the number of rows used in the report and where...
  2. F

    Sorting Row-Paired Data (Macro?)

    Hello All, I've got a very large data set (setup layout below), which I am trying to sort without disrupting the adjacent column references... Column "A" has the headers, while columns B+ have successive months worth of data (e.g. Jan, Feb, Mar, etc), however, the data is being sourced from two...
  3. S

    Macro to update spreadsheet from cover sheet

    Hi, I'm looking for assistance on the attached workbook. The objectives are listed below and the requirements too. Sheet 2 = Form Sheet 1 = Code List Sheet 2 has 4 boxes to input data from Sheet 1. The top 2 boxes work as required. The bottom 2 boxes are for adding or removing data. I...
  4. R

    VBA or Conditional Formatting to Insert a new row of data base on cell value.

    Hey y'all. I've been scouring the internet to piece together codes that would be able to accomplish the task at hand. I currently have a worksheet that has the names of clients (a), when their next meeting is (b), and was the meeting completed? (c). I'm trying to make it so, once a meeting...
  5. K

    Macro button to append data to another work sheet

    I have a spread sheet that contains 2 worksheets. the first worksheet labeled "information" and the second one labeled "updated list" when the user enters data in the "information" worksheet in column A1 and B1 I want the data to be added to the "updated list" worksheet cell Al and B1.
  6. J

    Append rows from 1 wb to bottom of another wb based on column values

    I've used this site many times for tips so thank you, but never posted a direct question. I'm an excel hack and I can do this task with a few 'hacky' clicks but I now have to put it into a macro for an 'end user'. 2 open workbooks: Daily Despatch Report & Ready to Invoice I need to copy all the...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top