takes

Greetings! So I am currently working on a project at my job. It is something that I can do by hand, but requires a tedious amount of time. I'll try to explain briefly and then I need help figuring out how to use formulas to make this easier. We create hot rods from the ground up. We have...

Hello, My spreadsheet sheet (macro file) has only 12 tabs and a few formulas but it takes ages to open and whenever I modify something it also takes away too long to save. As a result, most of the time Excel crashes - using excel 2010. It seems that the document is huge... is there anything I...

Need some assistance. I have a large spreadsheet with numerous names, dates and values for the period of 2013-2017. I need to find the count of unique dates in three different columns for each employees. I have been using the remove duplicate tab but that takes so long. I also used the...

Hi, I am looking for a formula that takes the Week Number, and sums anything in the relevant column but also based on the code as in the below example. So here I would want the total for all codes 'A1' in week '201809'? <colgroup><col width="64" style="width:48pt" span="8">...

Hi everyone, I have a list of my sheets down sheet "Welcome" Range C7:C200 I I'd like a macro that when i click on the cell it takes me to that sheet name. please help if you can. Thanks Tony

Hi to all, Apologies if this has been addressed before. I've been trying to copy values from one workbook and paste them transposed on a different workbook. The current macro using copy/paste transpose works well and does the trick, but takes forever to run. is there a way to avoid using the...

Hello, I have the below codes that run really slowly, it loops each sheet and find the dynamic range then set the printing area on each. it works but takes a long time (the workbook has about 130 sheets and it takes almost 30 minutes to loop through!) Can someone please help me revise it to...

I have a spreadsheet with many tabs that suddenly tripled in size. On most tabs, when I hit CTRL-SHIFT-END it takes me exactly to FZ500 - regardless of the # of rows and columns that I am using. I try deleting all of the extra columns to the right and all of the extra rows on the bottom, but...

I have a file that when being opened, the progress bar gets to about 60% and then pauses and the file takes around 2-3 minutes to open. The file is a template file and when data is added it can increase to around 18mb but when saving it takes even longer. I made some very minor changes to the...

I have a big Excel file over 20 Megabytes. I also have macros, formulas, activeX controls, shapes etc. in pretty well on all 15 worksheets. On one of my worksheets, If I want to hide only one row, it takes 10 to 15 seconds to hide and I can't figure out why. What could be the possible causes??

Hi guys I am creating a spreadsheet that will get used daily throughout the year. This means that the spreadsheet could get very long. Therefore I am looking for a way to create two floating buttons, one to take you back to the top and another that takes you to the last row where data was...

Hello, I have found a formula that returns distinct values excluding blanks, but I do not understand what the role of &"" is. The formula is: =IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B1, $A$2:$A$10&"") + IF($A$2:$A$10="",1,0), 0)), "") The formula returns the same results whether the...

Hi All, I fave excel file (1,600 KB) & I would like to save range A1:S10000 as PDF file. I'm trying to save as > PDF or XPS & it takes too long to Publish. Any Ideas? Thank you in advance.

Good evening, I am having trouble with a FORECAST formula. This formula works when the cells are hardcoded into the formula and the fotmula is copied across... =FORECAST($B2297,E15:E2296,$B15:$B2296) Now I have a calculated figure which resides in cell A1 and changes when a new row of figures...

I have the following formula in one of the tables. but due to large data it takes time to recalculate. how can i incorporate it into vba code? {SUMPRODUCT(RecTbl[NOD] * (RecTbl[NAME]=[@[ID]]) * (RecTbl[ TYPE]=LBal[[#Headers],[Taken]])*(RecTbl[END...

Hi there, I have a spreadsheet that loads in a fair bit of data - takes a couple minutes. During this time, I'd like to put a userform 'sign' on the screen that says "Data is Loading, keep your grubby hands away from the computer", or something to that effect ;) Anyhow, I can't seem to get...

Hi all, Long-time lurker now registered. Looking for a bit of help. I did a search on here for taking a row, for example from "Sheet1" and moving it to "Sheet2". The code works in principle however on occasion it takes two rows across. The key word is "YES" in column 'i' and the macro is...

I need to highlight(green) row B-R if the row number is odd which works.=MOD(ROW(),2)=1 I also need it to strikethrough row B-R if cell R has anything in it but the first condition takes away me being able to do strikethroughs unless the row is even. Anyway to get both? Thanks.

Morning All, On a daily basis I am looking to create a report that takes 50,000 circa rows of data and then compares it to another list of 130,000 rows of data. If I use a vlookup I might as well go get lunch as it takes so long to run due to the limitations of the pc memory etc. Can anyone...

Hi guys - I realize this is probably very simple to do but I'm not even sure where to start. I currently have a complicated sheet for recording weights that an athlete uses in the weight room that somebody in my grad program created. I have recorded a macro that takes the weights and other...