taking

I am copying one whole worksheet into another worksheet but it is taking way too long and excel displays a "Excel not responding". Here is my code Sheets("Sheet1") .Select Cells.Select Selection.Copy Sheets("Sheets2").Select Range("A1").Select ActiveSheet.Paste I have used this code many...

I have the below formula that am trying to paste but for some reason is not taking =, what am i doing incorrect =AND([@Date]>=Calculation!$D$2,[@Date]<Calculation!$D$2+7) See sample link the sheet is called Raw Data but is calling from calculation...

Morning All, I'm currently just starting out using onedrive and am having trouble getting some of my documents on my computer syncing with the onedrive counterparts given that it seems to be taking a very long time is there any way of creating a message box to show the status of the sync and...

So I have created multiple connections that query an SQL Server and have 2 running when I open the file in the background and then I call the other 4 in VBA since need to identify the user and pass it to the stored procedure it is calling. The issue is that it is slow...really slow. From...

Good morning folks! I am having issue adding in a ending to a formula to multiple by a percentage. The formula is pulling data from a different sheet to bring an ending number to a main sheet. I am taking a SUMIF of cells and looking for any cell that container (A) in it. If that cell does...

Hi Using the above notation: Sheets(x).Range(xx).select produce a run time error 1004 select method of range class failed. I have a VBA taking data from sheets(x).range(x) and placing it in sheets(y).range(y) What should be the correct notation for this simple task?

Hi friends, I took picture of my problem as it is easier for me to explain on it, as I cant fully solve this problem. So I have to determine percentage of discounts (F row) according to conditions in table on right side. 1) For different suppliers I have different discount rates on different...

Omigosh I'm about to lose my mind. Why is Excel taking me to the fifth cell in my formula instead of the first?! All that mattes here is that I want to go to CA325 if I double click or ctrl +{ (YES, "Allow directly editing in cells" is OFF) =(CA325*0)+...

I have to ask has anyone else noticed issues with excel 2016 being slow or is it my high quality laptop? I use a desk top at work and when scrolling large strings of data from top to bottom it is fast as it should be yet when at home on my laptop with this 2016 version and scrolling the same...

Hello, I have had a worksheet working fine for 9 months. It normally takes 2 minutes to execute the macro in this worksheet, but for some reason in the last two months it started taking 6-8 minutes to execute. I was able to isolate the code that was taking so long. Open kmfile For Input...

I have created a button on sheet2 but when assign it a macro for data on sheet1 and click it has been taking reference of sheet2. Please assist

Can someone look at this code and tell me what I am doing wrong? I am trying to add a column into a spread sheet by taking tghe information from sheet 2 of the workbook...

hi to all Good Evening I have values 1, 2, 3 in column A and then i want to copy them in column B like 1 2 3 1 2 3 1 2 3 1 2 3 like this for number of times i want. I tried index, Mod and offset but no success, now i am doing manually but taking long time, is there any formula to do so? if any...

does anyone know of an Excel stock data downloader that's up to date , currently still taking daily data from Yahoo , Google or others

Hey everyone! Was wondering if someone could help me out with a mystery. I have a macro that asks the user to save their Excel. I was looking if I could default the Save As Text to be the text from say H16 on the Active Sheet. So instead of taking the default name of the workbook they have...

Hello all, I have 2 different tabs in a Workbook. In sheet1 I have all the dates starting from A1 and so on. Now in Sheet2 in B2 i need the 1st cell say Sheet1 A1 but the next value from Sheet1 A2 i need to be entered in Sheet2 but in B12. The next will be Sheet 1 A3 to be entered in sheet2 B22...

Hi I am trying to scroll down all 3 at once and only change the number going from 8 9 10 11 leaving the letters the same. I cant figure out a way to do this and been copying and pasting and taking forever. =IF(Data!I8=0,TEXT(Data!I8,""),Data!I8) =IF(Data!J8=0,TEXT(Data!J8,""),Data!J8)...

I have a table that has a monthly drop down list and a team list. I have been able to figure out how to make the data change based on those 2 factors using an IF(AND) formula, however I am needing the data to locate to a different cell (XXXXXXX) as well but NOT change. Is it possible to take the...

I have a spreadsheet where cells A3:A10 contain bank holiday dates which I've given the Name 'BH'. They are in a sheet called 'Bookable dates'. In the same sheet in B3 (for example) I want to display a date which, taking =TODAY() which resides in cell W1, calculate the following, and be able to...

Is there a way to take an existing date in one cell and add a number of weekdays to it to determine what that date would be. I know you can add the total number of days such as taking 11/30/2017 and add 14 to get to 12/14/17, but what if I wanted to know what the date would be after adding 14...