microsoft 2016

Hi Gurus, I have 2 sheets and wanted to move the entire row at the bottom if the cell value is "1". Sheet 1 - Look for the value of "1" in Column C then move to bottom Sheet 2 - Look for the value of "1" in Column E then move to bottom I found this code but is it possible to fix the code...

Hello Gurus, Hope you had a nice weekend. I was trying to find a way on how to show the "Count of Indicator" but can't figured it out on Pivot. I was thinking that if it won't work on Pivot maybe IF formula or VBA would be helpful . Raw Account Country Data Score Indicator (value after...

Hello Guys, Hope all is well. I have a sheet with more than more or less 100k lines. I need to trim the data first by omitting rows with "0" or blank as Value in Row R (Sheet 1). I found below code but it's taking much time probably because the file is too large. Sub DeleteRow() 'DeleteRow ot...

Hi Gurus, Any thoughts on what would be the right sumif lookup formula for below scenario? Sheet 1 - I have a long list of Data. Simple example below: Name Change Sam 250 Mike 300 Sam -500 Mike -150 Sam -50 Mike -25 Sheet 2 - I'm having a hard time doing it in pivot so just...

Hello Gurus, I'm getting a syntax error on this part of my code. Anyone who can help me tweak the code below? = = = = Sub Check With Range("Z2") .Formula = "=IF(Z2<0,"Less",IF(Z2>0,"Add",IF(Z2=0,"Zero")))" With .Resize(Range("A" & Rows.Count).End(xlUp).Row - 1)...

Hello Gurus, I have a massive excel file with so many tab sheets. Some may be blank sheets so can you share some VBA code for this one? Appreciate if you have the code to hide and unhide sheets that are blank. Thank you!

Hi Gurus, Hope all is well. Is it possible to rename a file based on it's equivalent cell value and criteria? Scenario: I have different multiple files in a folder and in different file format Sample filenames in a folder 0001 Datasheetxx.pdf Dataaaaaasheetxx_002T.xlsx...

Hi All, I'm currently looking for ways on how I can hide columns in multiple tabs sheets. Hide Columns: A, C-E, H, K-P,V-Z Sheets to loop: Sheet1, Sheet1 (2), Sheet1 (3), Sheet1 (4), Sheet1 (5) and so on (example Sheet1 (6) Note: If sheet's doesn't exist, just skip. Any help would be greatly...

Hello Gurus, Good day! Could you possibly help me tweak below code? I have multiple workbooks and need to combine into one. I have below code that can do it. However, I am getting an error message whenever there is same tab name that exists on different workbook. Note that the tab name most...

Hi Guys, Happy New year! I found below code however, it seems like only column A of each sheet is being copied on the combined Sheet. Is it possible to adjust the range and copy everything except Row 1 for each sheet? = = = = = Sub Combine_Sheets() Dim startRow, startCol, LastRow...

Hello Gurus, Trust you are doing well at this times. I just wanted to get your thoughts on how to code this. I have a workbook with two sheets: Sheet 1 Date Account Reference 12/30/2018 5000 0001 11/30/2018 4000 0001 10/30/2018 3000 0003 09/30/2018 4000 0002 08/30/2018 3000...

Hello Excel Gurus, I'm trying to link my excel tabs sheets to a powerpoint template. However, whenever I run the macro, the charts overlaps in the slides. Is there any way where I can set the slide view to 100%? Whenever I open the PPT, its always set to 115% - not pretty sure if this is the...

Hello Gurus, Good day! Could you possibly help me amend the codes I found below: Basically, I am trying to create a PPT Template for my report - the charts, table format and tab names in excel are same. Is there any way to copy the format in excel (as seen in the excel print preview) on the...