spreadsheets

Okay, so I have tried to Google this issue and can't seem to find anything or I'm not using the right key words. I have Excel 2010, my boss has 2016, and a coworker has 2013. All of my spreadsheets are Calibri, font size 10 and all spreadsheets are autofitted. When my boss or coworker opens my...

Hi, My first post in this forum, so please be gentle. I have a client that has a workbook of c700 spreadsheets for which I have found a code to seperate the workbook each month into individual spreadsheets and then save in a folder and distribute accordingly. I am now looking to encrypt a...

Hello, Using the latest Excel on a Mac. Am a bit of a beginner with spreadsheets. This has really been driving me nuts trying to figure out. I have created two spreadsheets. As best as I can determine, they are set up identically. Can't find any difference in the formatting, or anything else...

Hi Guys, I need a macro that will search sheet1 vs sheet2 for all data in each column and row (multiple columns and rows). The rows do not match up 1 for 1. For example on sheet1 it could be row 10 but sheet2 it could be row 100. So I need the macro to do a unique function to find the number in...

Hi, lately I've had to work with some huge spreadsheets, usually about 200,000-300,000 rows and 300 or 400 columns. Many times when I have to run formulas, even a simple VLOOKUP or COUNTIF, the program freezes and sometimes crashes and I sometimes get an out of memory error message. Would...

I have a spreadsheet similar to this. I am filtering the column of numbers for the 3 highest, which works well. What I am wondering is how do I get the labels to follow the data? Say I have two spreadsheets. I am using LARGE to sort through one sheet and put results on a different one...

I have a line of code that was looking at the beginning and ending spreadsheets, but now they are adding more spreadsheets so instead of certain sheets defined I would like it to pop up a input box. Here is the code I have currently: "=IF(ISNA(VLOOKUP(C2,'12-31 TO...

Hey Everyone, So I've got an unusual problem with MS Excel that seems to be happening to (1) only me and (2) all spreadsheets that I open. (1) Every time I enter text into a cell, Excel will automatically insert "^" at the beginning of that text. For instance, in a header row I would...

Hello, I want to create a loop that will pull different store information into one spreadsheet. So I have 55 stores that we survey out and instead of opening up all 55 excel spreadsheets and copying over the information, I want to create a folder to save all the information in and have one...

When some of my macros finish running, I cannot use the mouse on the spreadsheets. I can use the mouse for other applications and can use the excel ribbon - but not on any spreadsheets. The curser works to move from cell to cell but not the mouse. My only solution right now is quitting Excel...

Hi there, I seem to have trouble that I haven't had before and may be that I'm not using the full functionality of excel 2016. I have a simple master spreadsheet that is linked to multiple spreadsheets and unless I have the actual linked spreadhseet open, I get the #VALUE ! in the master...

Hi guys, as may you aware there is an official Office app called ~. It's pretty amazing, and does exactly what i need. Before use of this i made some vba to done this. With that app you can export all the changes in 2 workbook but only the address of the cells. I would like to know is there any...

I have 12 spreadsheets one for each month of the year on which I track all our expenses. I want to tally a yearly total for all the expenses. The spreadsheets are titled Jan. 2017, Feb. 2017 etc. I want to have all totals on an additional spreadsheet following the same format as the other 12...

Hi. i got a win 10 custom theme installed. But it affects the background color of my spreadsheets. Is there a vba that can black any themes from affecting them?

Hi there! I have another question to ask to the Excel Masters: I would like to work with a Vlookup with three different criteria (X, Y and date), and I'm a bit stuck when I tried to use it in Google Spreadsheets... My goal was to avoid creating extra side columns with the values X, Y and...

I am seeking advice on how to link two spreadsheets on a sharepoint site. What I would like to do is have a cell in one spreadsheet reference two other cells in the same spreadsheet and then cross reference those with the same two data cells in another spreadsheet and if the data matches from...

Hello, Workbook A picks up data from workbook B. However, each time I have both spreadsheets open, all my formulas in workbook A will spit out the error #REF ! Any idea how to stop this from happening? I've been avoiding opening both spreadsheets at the same time in the past but surely there...

I noticed in looking at some of the posts, some participants are able to add screenshots of Excel spreadsheets in posted messages. Could someone explain how this is done?

Excel 2013 64-bit I have procedures to add right-click menu options that I want to call whenever a workbook is open. The code is in the ThisWorkbook portion of personal.xlsb. Private Sub Workbook_Open() AddShortCuts AddNewVBEControls End Sub However, the code is not executing when i...

Hi everyone. I need some help creating a spreadsheet to calculate revenue from different businesses, and I want to keep all the data separate. But, I also want the data to interact with each other on one master sheet. There is also data that is the same across spreadsheets that it would be...