newsheet

  1. B

    Combining information from frequently adding sheets

    Hello! I have one excel sheet with one combined data and aditional information and sheets who are added frequently. I need to add column in combined sheet where data is recovering as new sheet added. I'm the beginer in excel for now I needed only standart solution. But here is new job and new...
  2. W

    VBA code taking too long to process

    Hi, I have a macro that copies data into a separate sheet (after converting a matrix to string for three columns - date, time and value). It works fine apart from the fact it takes too long (approximately 5 minutes) to copy across. Although there is a large amount of data is there a way of...
  3. G

    Add a worksheet with the name of a selected cell (which changes)

    Hi, I'm struggling to work this out despite me thinking it really cannot be hard (still very much a newbie). I want to select a cell in an existing worksheet then run a macro that inserts a new sheet (at the end) and names it the contents of the active cell. An added bonus would be to Paste...
  4. J

    copy values only from range of cells containing formulas

    have sheet that contains data that constantly updates. need to do the following; when sheet opens, create new sheet with Date as sheet name, then copy values only from original sheet in A1 copied to newsheet A2. then if A1>A2 copy value only of A1 to newsheet A3, if A1<A2, copy values only...
  5. J

    copy multiple rows to new single row sequentially in new worksheet

    excel 2016 I have 40+ columns of data in 100s of rows. At a specified time each day I need to copy each row sequentially to a single row in a new worksheet. As an example: DataSheet is the sheet from which data should be copied. NewSheet is the receiving sheet. Process would be as follows...

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