muliple sheets

  1. C

    Excel VBA Code for copying data from any updated cell in specific column from one sheet and pasting it, with timestamp, in another sheet

    I have 2 sheets involved: Sheet2 (Asset List) Sheet3 (Asset Location History) This is my current code in Sheet2 (AssetList): Private Sub Worksheet_Change(ByVal Target As Range) Dim xLocationColumn As Integer Dim xUserTimeColumn As Integer Dim xRow, xCol As Integer Dim xDPRg, xRg As Range...
  2. R

    COUNTIFS in External Sheet, Over multiple sheets

    Hello. I'm hoping someone will be able to help me with this one, I'm looking to search an external workbook for any occurrences between 2 dates. The dates are obtained by looking up the dates from a business calendar which is in a separate sheet. That is retrieved by the HLOOKP function I've...
  3. D

    How do I auto transfer rows of data from multiple sheets into a different sheet

    Hello all, I am after some help with excel. I am a PE teacher and need to find a way to cut down the processing time for our athletics carnival scoring system. One way is to use excel to automatically sort through some of the data for me. The problem is Im not savvy enough to set this up and...
  4. S

    VBA: Creating formula on all worksheets dynamic ranges

    Hi :) I am guessing there is an easy solution to this, but I have spent hours attempting to locate with no success. My apologies for the code potentially being klunky, as I piece together code over various searches based on my needs. This code is a piece of a much larger macro which is why it...
  5. K

    copy and past from multiple sheets in a separate workbook

    Hi all, I've been able to put together the following code with the help of many post by other members. Problem: I need to modify the code to copy the same range of data from multiple sheets into a summary sheet which is located in a different workbook. I cannot get the following code to run...

Watch MrExcel Video

This Week's Hot Topics

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
Top