spreadsheet

Hi I realize the title is not that helpful I have a relatively large spreadsheet - around 7 MB - with a lots of calculations and 50+ tabs It calculates fine and very quickly. However, my problem is that if I move a tab or insert a blank line (even if that line does not impact any...

Can anyone provide me with a quick way to remove every other row in a spreadsheet report?

Hi folks, I have a spreadsheet which I've been using successfully for months. I updated it this morning with some text. To achieve this I had to unprotect the spreadsheet and unfreeze panes. I made my changes, put freeze panes back on, protected it again and then saved it. Now when I try to...

Hello All, I have a spreadsheet with some code for auto-population of cells, this requires the spreadsheet to be saved as "macro enabled". The problem I have is that the code cannot run in "Shared" mode. So I would like to add in some further code to automatically save then close the...

I am not even sure if this is possible or not, but here it goes. I have two spreadsheets. Each spreadsheet lists a bunch of parts and part numbers. Spreadsheet A is the database of existing parts in the system. Spreadsheet B is a list of parts from a batch. In Spreadsheet B I want to be able...

Hi I have over 500 workbooks, I want to add the workbook name in column AD for every row with text in it for all 500 spreadsheets. I plan to merge them into one master spreadsheet but I need to know which spreadsheet the data came from. Can someone please help me with the first part to add the...

Hi Guru's/Geniuses, I have a template which uses VLookup to get data from a master spreadsheet. All of the lookup data is from a list of code numbers on the master spreadsheet. I need to be able to: 1. Open the template 2. Insert the code number 3. Save the file as the code number (plus...

Can anyone help please, I have just added a picture vlookup into by spreadsheet that has now made the spreadsheet run so slow, some times I am waiting up to 15 seconds to move the cursor around the spread sheet. I have in 2 of my 20 or so VBA codes added the following, which did help speed it...

Hi there, I'm working on developing a spreadsheet that locks down all data entered to text only - and contains no formulas, and will not allow recording of macros. So I locked down the format of the worksheets to text, and the structure of the spreadsheet to not add more worksheets, and...

There are headers in the top row for all columns. There are no gaps between columns. Columns A, B and C are frozen. I put autofilter on and it's fine. Then sometimes after I have been merrily using the spreadsheet for a while I notice that columns A and B are not in the filter. This is...

I am working on an employee attendance spreadsheet that is based on a point system. Point values are associated with different absence reasons and tracked on a rolling 12-month calendar. I was able to successfully complete a spreadsheet to take care of this part. However, I am unable to figure...

Is there a way to do data validation to prevent text entry in a cell without using a macro? We also want to be able to copy data into the spreadsheet with the data validation.

Hi I have a spreadsheet that contains among other columns, 2 columns. They are start time and end time. Their format is 7/1/2019 2:17:11 AM for example. Of all the start times, I want to ONLY retain the information where the start time is */*/2019 21:00:00 PM and the end time is */*/2019...

Hi there, I am completely new to excel and I was unaware of the extent of its functions. I have been tasked with converting the layout of a cinema timetable that is in a spreadsheet. the timetable also includes the age rating of the movie and the director . I am also not going to include certain...

Hi, Hoping someone can help please, Does co-authoring in excel online (document is stored in office one drive) support cell protection? Id like different users to have specific access to parts of the spreadsheet. But from what I can see this feature doesn't seem to work when editing the...

Hi I am looking for a formula that can vlookup based on multiple criteria. I need a formula for F4 (on spreadsheet 1) that will look up the value of column F (on spreadsheet 2) if column E (on spreadsheet 2) equals "Claro" and Column A equals the site number in A4 (on spreadsheet 1) and column D...

Hello everyone, Here is my problem, I have the following spreadsheet: <tbody> A B C NC 1 Name 01/01/19 01/02/19 12/31/19 2 Franck F IC O 3 Larry O O F 500 Patricia F F IC </tbody> The data in it has to be used in another spreadsheet which looks like...

Hi, Can someone help me with the vba for the following- I have 2 tables in different spreadsheets, which have a common field -policy no. The main table is in spreadsheet 1 and the other in spreadsheet 2. What is required is to find the number of times a policy no repeats itself in the second...

Hello, this has been an on-going issue but now it's getting out of hand. My excel crashes, I can't close it from the taskbar nor can I CTRL, ALT & DEL, so have to power down. Usually I've got 6-7 spreadsheets open working on a 3 screen setup. Since last night, I tried a few different ways...

I posted on here before regarding a sumifs formula and I appreciate the help that I received. Now I am finding out that it is not picking up all the data that I need and my boss wants to make this into a macro after I figure out how to make the formula work since this formula is so cumbersome. I...