1. S

    Creating a Name to Time to populating a calendar formula

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

    Macro file doc takes too long to open

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

    Unique dates

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

    Sum If based on selection

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

    Macrp to goto sheet when i click on a cell

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

    Avoiding Clipboard

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

    VBA set printing area for all sheets in a workbook - takes too long to run

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

    Can not remove empty cells

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

    5mb file takes long time to open and save

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

    Hiding one row taking 10 seconds

    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??
  11. M

    Floating Button that takes you back to last data entry row

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

    &"" in array SUMIF

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

    Big Excel range to save as PDF takes too long time

    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.
  14. S.H.A.D.O.

    Problem with FORECAST formula.

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

    Sumproduct into vba

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

    Show userform as long as sheet is calculating

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

    Macro's : Cut/Paste from One Sheet to Another

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

    Conditional formatting based on 2 different conditions

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

    The best way to compare 50,000 rows of data to another of 130,000? Vlookup to slow

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

    Extracting data to another tab and filling it in vertically

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

Some videos you may like

This Week's Hot Topics