compiling

  1. K

    How can I post sources file name next to source data pasted into compiled workbook

    Hi everyone! I am relatively new to using macros and have been having some trouble using macros to compile data into a new excel sheet. My goal is to have a sheet that looks as follows: Item Name Measured Value Source File Name A X Patient1.xls B X Patient1.xls C X Patient1.xls A X...
  2. Z

    Compiling Values

    Hello, So I am trying to track the status of multiple work products on a day to day basis using Excel Macros. I am trying to run a loop checking each row in sheet 1 against sheet 2. And if the value doesn't exist in sheet 2 then inputting it in sheet 2 towards the end of the records without...
  3. A

    WTA - How to compile multiple workbooks (with filtered data) and the header need to preserve as they are similar in each files

    Dear experts, please help me out to get the code, . I need to write a macro that can do this things : . there are 3 files (A,B,C) - contains single sheet each, in a specific folder that need to compile into a single worksheet : - first, need to filter the years (select 2017,2018 only for all...
  4. J

    compiling data from multiple sheets

    can anyone create a macro to achieve the following: I receive multiple copies of a spreadsheet template from our field reps with their specific data on each one. There is a tab on their spreadsheets called ‘Summary’. I would like to start compiling data from this tab from all the reports I...

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