multiple sheet data

  1. J

    Checkbox - True - Moves Whole Row To Another Sheet

    Hi Guys, New the threads, so thought I'd give it a go. I'm stuck, I'm creating a workbook that we use for our tender submissions. What I now want to do is when a check box is ticked i want to move that row to another page (not the whole row - i.e. only move a5,b5,c5 across to another...
  2. L

    VBA Match Cells, Copy Adjacent Cells

    Hi all - I've been searching for days for a solution and have yet to find one that works. Doesn't necessarily need to be VBA, but I think it has to be as formula's don't seem to work. I have 2 sheets "Split Request" and "Hidden". Split Request has account numbers in cells E9:E47. These are...
  3. S

    Excel Sharepoint Help: Conditional Formatting & Data Autofill

    Hello, I have a spreadsheet on Sharepoint that I'm trying to make work. The purposes: To allow people from our building can add their name and birthdays. To have conditional formatting that automatically highlights all rows containing dates from the current month. To automatically populate...
  4. A

    Auto populate the newest data into a master spreadsheet

    Hi Everyone, I'm hoping you can help. I receive a weekly report which I move into a folder, the name for the report will be different each time. What I'm aiming to achieve is to auto populate the data from the most up to date report into a master spreadsheet. I was wondering if the lookup per...
  5. K

    Rolling 90 Day Average over Multiple Sheets

    I am trying to calculate a rolling 90 day average of results. Each sheet references a month and are titled as followed January '21, February '21 etc. Within each of these sheets I collect scores gathered on a certain date. Column C contains date that result was collected and Column D contains...
  6. W

    link multiple spreadsheets into 1 spreadsheet

    I have a workbook that currently has information that will go to 2023 that I will be using for reporting purposes. I am trying to set up an automated workbook to have an automated tab that when information is inserted on the 2020, 2021, 2022 or 2023 tab (formatted as a table) that it inserts the...
  7. A

    Coded needed to take a row from mater sheet data and copy into other sheets in workbook based on a condition

    Been hunting the internet trying to figure this out and I give up so hopefully someone can help me out here. So overview is customer list and trying to break out customers by sales rep into their own sheets in the workbook. Just trying to set something up for a CRM while we are dealing with...
  8. L

    Matching data on multiple sheets

    Hi All - Is there a way to compare data in a column of one workbook tab with data on another tab (multiple columns) to see if there are ANY matches in the string of data?? For example: Sheet 1, Cell A1: "Red, Yellow, Car, Truck" Sheet 2, Column A is "Color" and Column B is "Vehicle Type"...
  9. U

    Vlookup alternative or if function

    I have data in multiple excel sheets in the same workbook. All sheets have the same table but different data as each sheet represents a certain date. The name of shops in the table are chosen from a dropdown list and you can see the full list of shops to the right of the photo. What i want to do...
  10. N

    Vlookup over multiple sheets

    I am using an xl file with multiple sheets and have a front sheet at the start where i am cosolidating results. what i am trying to do is a vlook up across the other sheets which will return the stock count of a part number. this is the code I am using...
  11. M

    VBA to Index/Match from Required Tab

    Afternoon all, I have the following: 4 x data tabs (all in the same format in columns A to M, with the lookup refs in A1:A30 (unique ID) and months in B1:M1 1 x summary tab On the summary tab: From a dropdown in A1 I want to select the tab name (i.e "Sheet1"), and I then want the below cells...
  12. U

    Copy Sheet Format to Multiple Sheets

    Hi Guys, I've made research about this but can't find the right one. So I have this excel sheet named "Subject" with multiple sheets (sheet A to D). What I need is to find the codes wherein the macro will copy the entire format of Sheet A to Sheet B,C & D. Any help will be much appreciated.
  13. B

    VBA Copy Paste

    I really need some assistance if someone could help...likely really easy for you guys. I have been searching for examples I could use for 2 days... I am trying to use VBA to copy data from multiple worksheets within a workbook to a worksheet called "Data" within the workbook. - copy multiple...
  14. D

    Conditional Formatting Assistance...

    I am trying to assist someone with reconciling all of their business financial information into one excel workbook. It has become a little complicated now that I have worksheets for bank information, time keeping information, and multiple quick book exports. I have noticed that the check...
  15. L

    Multiple Referencing Between Workbooks

    Hi, Recently my boss has requested I take on a job which my predecessor used to do which is meter reading. I'm happy to do this as its a very simple task but it is very time consuming, this is because on the site I work on there are multiple tenants who require a separate workbook for their...
  16. B

    Using Excel to copy data from a "form" into a database.

    I'm not sure how to word the question accurately so I have included some Pictures to aid me. Using Excel 2010 I am trying to copy data from one sheet, the "Form" to a database called "Master" but the data needs to go into a Row that corresponds with employee's pay numbers. This is the Form...
  17. R

    Data needed from large workbook

    Good day- I have a workbook setup as follows: Sheet 1 has 50,000 records with several columns of data related to a specific column - let's call that "codes". Sheets 2-31 have duplicate entries of some of the records from Sheet 1. What I would like to do is add a column in Sheet 1 that would...
  18. P

    Poker Leaderboard: help requried with fomula improvment

    Hi Guys, I have recently been put in charge of maintaining the leader board for our poker league. For the past 8 months data has updated manually after being calculated first. I have been trying to come up with a better way but I can’t seem to make my formula’s work for me. Currently the...
  19. J

    Return Value from one tab to cell on another tab based on threshold

    I have a report that I'm responsible for managing that comes in weekly from several different members of my organization. They are sending certain statistics on each facility of our organization, which I then copy into a tab for the week in a master file and use the information reported by each...
  20. E

    Unable to combine multiple (autofltered) sheets into a single worksheet

    Hi, I am not a vba expert and have been looking for vba codes online to help with merging multiple sheets into a single sheet. Basically, I have multiple sheets that I have already filtered out for blanks in Column B. I would like to transfer that data of each spreadsheet (Column A-G, from...

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