spreadsheets

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...

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...

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...

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!

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...

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...

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

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...

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

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...

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...

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.

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...

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...

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...

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...

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...

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"...

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...

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...