multipe sheets

  1. R

    VB help in Combining Data from Multiple workbooks into a single workbook with same headers

    Hello Everyone, Is there a way to combine data from multiple excel files into one single sheet by appending data? All the files have the same headers. Also these sheets have drop down list and conditional formatting. Is it possible to append the original data with all the conditional formatting...
  2. S

    using formulas to sum on various pivot table columns using criteria from other tabs and tables

    Hello, I have the following formula on one tab of my workbook which presents a client directed view of costs and hours for groups of resources which are described in a pivot table on another tab. =GETPIVOTDATA("Sum of Tot.Pro.Hrs",'Resource Costs by...
    • Sfraizingr
    • Thread
    • dynamic cell reference formulas formulas from columns multipe sheets pivot table
    • Replies: 1
    • Forum: Excel Questions
  3. B

    Please help with trying to take data from Sheet2, based on data from Sheet1, then pasting it into Sheet1

    I am not Excel Savvy at all and have spent the better part of the weekend trying to learn/figure this out but have hit a wall. Work has tasked me with creating a spreadsheet that holds the records of 1000 or so employees and their regular tests. To achieve this I have created a manual entry...
    • BrisAdrian
    • Thread
    • auto fill cells help excel formula please multipe sheets reference cells
    • Replies: 3
    • Forum: Excel Questions
  4. A

    if cell is contains value then copy row to next free row onto another sheet

    Hi, I have a multiple tables on multiple sheets that are upadated through a sql query. I then search these sheets for cretain text and copy these rows to a spearate sheet called other tickets using a vba macro. Sub OtherTickets() 'ActiveSheet.Unprotect Dim r As Range, c As Range, j As Integer...
    • aamarb
    • Thread
    • copy & paste values copy new data row multipe sheets vba
    • Replies: 1
    • Forum: Excel Questions
  5. N

    Data from consecutive rows to alternative rows within multiple spreadsheets

    Hi, I have multiple same templates on my sheet 1 of excel file which has to be filled with data from sheet 2. The problem is the data is sheet 2 are placed in consecutive rows. The usual copy paste is not working. Can someone help. [/IMG] Sheet 2: Sheet 1...

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