muliple sheets

  1. A

    Multiple Criteria Look up: Which Function to use?

    I am trying for a formula to cross reference between the number of sessions John Doe has purchased and the days they are valid to then countdown each time a session is used up. Formulas to go in the following columns: Column F for the Gym locations Column G for the Outdoor locations Screenshot...
  2. Y

    Wrong Copy Data from Several Excel file

    Dear all Good day i am having problem on copying data from 3 excel file to 1 master file. i want to copy from source excel file to 1 master file this is my code : Sub CopyData() Dim Fname As String Dim scwbk As Workbook Dim dswbk As Workbook Dim a As Range Dim b As Range...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...

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