spreadsheets

  1. 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...
  2. 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!
  3. 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...
  4. 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...
  5. 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
  6. 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...
  7. 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
  8. 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...
  9. 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...
  10. 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.
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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"...
  17. 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...
  18. 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...
  19. B

    Linking multlple spreadsheets to a master spreadsheet

    Afternoon, I am looking to link various cells from multiple spreadsheets to a master spreadsheet automatically without overwriting the previous data. The purpose of this spreadsheet is to create a master log of work done for all sites, the individual spreadsheets are basically a time sheet...
  20. A

    Run a Macro for multple spreadsheets at once

    I'm wondering if there is an easy Visual Basic program that can do this: I have multiple spreadsheets (any where from 1 to 300 on any given day). For each of these spreadsheets I need to run the same Macro and then save the result in a specific folder. Is there a way to do this in a batch where...

Some videos you may like

This Week's Hot Topics

Top