guys

Hi guys, I am having a brain freeze. If I have a number of 700 (A1) but I only want to calculate the difference if its plus or minus 5% of it what formula should I use? I wanted to attach a file but I cannot see the option and do not know how to do it. Thanks TJ

hey guys, I need a macro to make all data in one column of variable size do this: if data in a cell of the column M is bigger than 900, subtract 900. Afterwards, if the numbers 33 and 34 pop up, they should be changed to 13 and 14, respectively. This is pretty basic stuff, but I don't know the...

Hi guys, I get confused as to the syntax between SUMIF and SUMIFS. Do you know a way you guys can remember each syntax without getting confused one with the other?

Hi guys, I use that formula =RANDBETWEEN(MAX($B$2,$A$2-(($D$2-ROWS($A$4:$A4))*$C$2)),MIN($C$2,$A$2-(($D$2-ROWS($A$4:$A4))*$B$2))) But i get some error like that. I can not solve this problem :/

So I need help writing a code that will effectively move this data, ignoring column C and F in the source and put in the new sheet, in a different location. But it just puts it in the next available row, so in the example, as I add more Cool Guys, it wont overwrite my current list of Cool Guys...

Hi Gents, I'm struggling on the above subject guys. Any help! Many thanks.

I'm have issue running this code. I keep getting getting a compile error: for without Next. Can you guys please help. Sub DeleteRows_BASEMENT(IRibbonControl) Dim sht As Worksheet, myShts As Variant myShts = Array("PARENT VIEWS", "Child Sheet Index") '<-- list all the sheet names you want the...

Hi guys, Got a question about VBA. How can I select first 4 sheets using VBA? I know I can do ActiveWorkbook.Sheets(1)...but how can I select first 4 sheets but not all of them? Thank you!

hi guys - i'm totally new at this VBA stuff... i'm looking to apply the code below to 2 other sheets ("Sheet1" and "Sheet2"). the code i currently have is: Private Sub Workbook_Open() With Worksheets("Main") .Protect Password:="password", Userinterfaceonly:=True .EnableOutlining =...

Sorry, new here first post. I have an excel spreadsheet with a slicer table pulling the results and everything is going into a single cell I cannot do text to the column it does not work correctly for me can you guys please help me. Where can I import this spreadsheet so you guys can take a look?

Hello guys, i would like to ask if is it possible to filter a column that contains a specific data in macro. For example i would like to filter out data that contains 9000 or 5000. But the data in the column for example is 500012312. How would i do it? TIA

Hi guys, I have this spreadsheet. I need to be able to work out how many days holiday each candidate has accrued based on todays date. For example. Based on the amount of days worked per week and how long the contract is for, CAN-10367 will get 30 days holiday for the duration of his...

Hi guys, Newbie here, I just want you to help me. Here is the situation, If I was hired last year March 6, 2017, they have given me 5days of leave (SL/VL) per year. How many days I've earned for last year that I can use this year? I just want to compute my leave earn daily by putting a formula...

Hi Guys,Gals..

Hello, In my script in some part Im useing autofill and it works proprly but when I have 2 or more records. If there is non or one record my macro is crushing. I have something similar in several places in my code. I just need to have Id in column A from A2 going downn (1, 2, 3 etc) and none...

Hi guys, Worksheets("Extract").Range("GCMR_Data_Table[CRMSID]").Select The above code is giving me "Select method of Range class failed". Would you guys be able to tell me where I'm going wrong? I'm trying to select the data in column CRMSID from the GCMR_Data_Table in sheet called Extract...

Hi Guys, I want to add a number to each row, starting on A3 with 0, A4 1, A5 2, etc. Until the last row in column B is reached. Can you guys help me?

Hello guys im having trouble doing the following: My goal is to have =SUM(B25*E2, B24*E3, B23*E4, B22*E5, ... means that each time that I drag the column down it multiplies it for an E but oging cells upwards. Any way to easily do this instead of manually doing everything? Thanks guys!

In colume C & D I use the following formula to look into =INDIRECT(ADDRESS(SUMPRODUCT(($U$2:$AX$932=B5)*ROW($U$2:$AX$932)),(SUMPRODUCT(($U$2:$AX$932=B5)*COLUMN($U$2:$AX$932)))+1))...

Hi all, I need help for this. A1 A2 A3 0 0 just Blank (if both cell contains 0) 12 12 Completed (if A1 and A2 are equal) 12 14 incomplete (if A1 and A2 is not equal) I just want output in A3 to be displayed. Thank you guys.