step

Hi All, i need your help... i dont know anything abt macro..but i try to learn. i need a macro script in a way which communicate with a website and do the actions which i want. for example take a gmail webiste. i want the actions like this with the help of excel macro step 1: open the...

I have data something llike this a b c d e f g h i j k l 1 2 1 1 1 10 21 23 32 34 43 45 3 11 2 0 22 33 44 4 12 3 1...

I have a Personal.xlsb file with several modules. I recently changed over from 2010 to 2016 (O365). Prior to, all macros in the Personal.xlsb file worked as they should with no errors. Each macro is a two step process. Step one, formats each tab of an individual spreadsheet and step two...

Hi fellow Excel users and fans, Huge problem here that is freaking annoying. Hope you guys can help. I've built a beautiful Excel with: 1. PowerQuery to bring in Data; 2. PowerPivot to link them together. For step 1, I refresh the queries just fine. But for step 2, when click Refresh All in...

I'm trying to make a data entry worksheet that has a macro button to make a copy of the sheet and save the data to it so as to retrieve it at a later time. This is the code I am working from currently, but I keep getting an error. Sub Macro1() 'Step 1: Tell Excel what to do if error On...

<tbody> Challenge 1: What you know: The employee is in pay grade 3 and rate is $25.30 Challenge: write a formula that looks up the grade, and then returns the value on that range in which $25.30 is nearest to (rounded down) Challenge 2: Write...

Hi all, I'm pretty new here. I have been struggling for quite awhile with a present code which i would highly appreciate if i could get some help. I have a workbook with multiple sheets on it, and would like the VBA code to loop through all the worksheets, copying table from two cell ranges...

I started a previous post but I think I over-complicated it, so I will try again with (hopefully) a better explanation of what I'm trying to achieve: Sheet "Dates" contains dates from A2:A200 (the range can be less or more) Step 1: Copy the first date from "Dates" sheet in cell A2 Step 2...

Evening All Is there a possible shorter way to delete Columns with No Data. Thanks Sub DeleteBlankCol() col = Cells(1, Columns.Count).End(xlToLeft).Column For c = col To 1 Step -1 If WorksheetFunction.CountA(Columns(c)) = 0 Then Columns(c).Delete End If Next End Sub

Shortly: I need the range of A1:B3, then A3:B5 then A5:b7 _______________________________ Parts of my thoughts, but it leads nowhere because I can't make a code from it, these are just parts of it, but I can't combine them in the right way: So I have 2 variables: Dim i as integer dim j as...

Dear All, I am very new to Access. Need your help to know how to change Date to Day i.e. 1,2,3.....31 with Day() function. Please assist me step by step. Regards, Shan

Sub Financiël_Gevel_€_M²_JAAR() Dim i As Long Dim j As Long Dim k As Long Dim l As Long For i = 3 To 4001 Step 4 If Range("F" & i).Value = "Elektriciteit" Then For j = 3 To 4001 Step 4 Range("L" & i).FormulaR1C1 = "=r[-1]c*r5c34" Next j ElseIf Range("F" & i).Value = "Aardgas" Then...

Hi My name is Husayn i am new to MS Access, want to learn access suggest site or some videos which can help me to learn Access step by step. Regards Husayn.

Dear all I am trying to understand the logit regression code below and although it is a function I tried to run step by step as a sub to understand it. the xraw and y ranges in this context doesn't work, it gives me an error. then I've replaced the N and K by: N = Cells(Rows.Count...

I am trying to combine 4 excel formulas. Can someone please help. Thank you. On sheet called Tracking in Cell AF2 I’d like to create a formula with these rules… (STEP 1) IF X2 contains the word Apple OR Oranges return VLOOKUP(B:B,Math!B:Z,18,FALSE). (STEP 2) IF STEP 1 returns value of 0...

I have a field in a table that should show me the number of months between two date. Is is possible to due the calculation between the two dates and store that value in the field? Does this have to be a two step process? Do I create another field to do the calculation (one that has a...

I have the following VBA code that will delete columns that are entirely blank. I would like to modify the code so that if a range below the first three rows (headers) is blank, then the entire column will be deleted. Can anyone assist please? Sub DeleteBlankColumns()'Step1: Declare your...

Hi Guys, I need a macro that will search sheet1 vs sheet2 for all data in each column and row (multiple columns and rows). The rows do not match up 1 for 1. For example on sheet1 it could be row 10 but sheet2 it could be row 100. So I need the macro to do a unique function to find the number in...