1. M

    Spreadsheet to calculate overtime and total hours

    Hi I am needing help to create a formula within my timesheet tracking spreadsheet to track the number of hours my team have worked during a working week to assist our accounts department to ensure they are receiving the correct pay. Our working week is Monday to Friday and we work 8 hours per...
  2. W

    Help! Formulas Disappearing After Every Save

    Hello, I have a problem that I can't find any information on online. I hope someone here can help me. I work with excel workbooks that have several spreadsheets (tabs). On some of the workbooks (no rhyme or reason I can find), any formula that is pulling data from another spreadsheet within...
  3. V

    Three spreadsheets to become one

    I keep records of electricity, gas and water consumption, which at the moment are on individual spreadsheets. I want to create a functioning spreadsheet of three original sheets to contain those I first mentioned. Copy and paste seems not to work, as each new item posted to the recipient sheet...
  4. V

    Combine 3 spreadsheets

    Hey! I need to combine 3 spreadsheets into a big one but I dont know how long each one will be. What I have so far is a short macro that merges them together and then deletes the blank rows between each other, but his seems very clunky. Anyone has a quick fix for this? Thanks!
  5. C

    Updating values between 2 different spreadsheets by 2 different users

    Hi all, first time poster here. Hoping someone can help. I've created 2 spreadsheets to use in a mock scenario for testing my department's flood response procedures. On the 1st spreadsheet (called Location), I've written a macro to constantly increase the value of the river levels every minute...
  6. P

    Insert Column with the same format + size as rest of tab

    Hi I have set excel so all new spreadsheets open with same font and size. Where I need help is when I insert a new column into other peoples spreadsheets the font changes and the size increases. I have a spreadsheet with a MACRO inserting a new column and I then have to spend time resizing and...
  7. Mandark39

    Looking for a tutorial to learn making this ?

    This is the only picture i have of this Excel sheet . It had daily expenses , Invoice details , Incomes , Total sales , Total expenses and a few more things . Does spreadsheets like this have a name ? How can i learn to make one like this ?? Thanks
  8. V

    VBA to break a spreadsheet into many within a zip file

    Hello. I am new to forum, a novice in excel and learning VBA. I have a request from my boss to see if I could develop a button that will break up a single spreadsheet "billing" file into multiple spreadsheets to upload into our billing software. The specs would include: 1. A new spreadsheet...
  9. W

    Reference cells to cells in other spreadsheets, even when sorting

    Hi I have the need to reference cells in 3 different spreadsheets but they change every time I sort the data. It's a little complex to explain - is it possible to upload samples ? Thank you in advance :) Wayne
  10. R

    'Locking down' spreadsheets

    Sorry - probably not the best terminology in the title, but I haven't had my first coffee yet! I just wondered how those of you who work with spreadsheets that are edited by multiple users go on. I am our office's unofficial Excel expert (even though I am VERY far from expert). And I make the...
  11. C

    Macro to Filter and Delete Rows

    I see posts for this but can't seem to get any of the solutions to work. I have spreadsheets that will contain numerical and text values in column F. The number of rows on the spreadsheets will vary. There is a header row. I need to filter an array in column F (i.e., 1, 2, C14) to the end of...
  12. M

    Fusion many pages in one book

    Hello, I need to consolidate a lot of spreadsheets in one book. All have the same format and fields. I need something that it could be sure and not lost my information.
  13. H

    Opening spreadsheets in separate windows

    How can I set Excel to open spreadsheets in separate windows when opening new/previously saved spreadsheets? Currently I have two work laptops, main laptop opens each spreadsheet into its own window. Alternate opens each spreadsheet into one window, main laptop is running Office 2013 alternate...
  14. T

    Copying and Pasting Data from Several Workbooks

    Hello there, I have 7 spreadsheets in folder S:\MHS\Review I would like to copy and paste the data from these 7 spreadsheets to a master file (which ideally would be the 8th spreadsheet in the same folder). Very basically... Range("A1").Select Range(Selection...
  15. Y

    Formula needed to repeat pattern

    I have to populate various spreadsheets using the following number sequence: 1,1,1,1,1,1 2,2,2,2,2,2,2,2,2,2,2,2,2 3,3,3,3,3,3 4,4,4,4,4,4,4,4,4,4,4,4,4 etc.. So basically, I have to follow sequential numbers in the special pattern of 6 instances of 1, 13 instances of 2, 6 instances of 3...
  16. A

    What did I do to the scroll bars in my UserForms?

    I was messing around with a calendar form and all of the scroll bars in all of my userforms, several different spreadsheets, stopped working. The "sliders" can't be grabbed and moved and the mouse wheel no longer scrolls. It's only in UserForms, the scrolling in spreadsheets works fine. I've...
  17. H

    Help a student

    Hi Guys, I'm currently at college, and on my new course, we have started a module that goes over spreadsheets. As I am very new to using spreadsheets, would it be possible if anyone could give me any guidance on completing this task? I will attach a dropbox link for you to view the question...
  18. A

    #VALUE! error in cells linked to other spreadsheets

    I have created a master spreadsheet with links to four other spreadsheets which shows the correct results when all linked files are open. However, if I open the master spreadsheet alone the linked cells show #VALUE ! rather than the value. In case this is relevant the linked cells are a "SUMIF"...
  19. C

    Consolidation Macro

    Hi There, I have multiple spreadsheets that I want to Consolidate into one. I have a macro to do this where it's just one tab per spreadsheet, however I need one that does it across multiple tabs & multiple spreadsheets. Obviously the tabs are all different names which is another difficulty...
  20. C

    Close Spreadsheets after macro runs

    I am running a macro that goes into another application (SAP). In SAP it downloads data and exports it to an Excel file. by default when you export a file from SAP it automatically opens up (I don't want to change this default). But the spreadsheets don't open up until after the macro is done...

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