exce help

I'm working on a web page where data from excel sheet gets copied, now the problem which I get is when my code click on submit, a new page loads with different url.. and my codes next line don't work, to look out elements to fill the data... How to code in such a way that my code keep on working...

Hi all I'm using this code that I saw in another thread: Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("B2")) Is Nothing Or _ Not Application.Intersect(Target, Range("C2")) Is Nothing Or _ Not Application.Intersect(Target, Range("D2")) Is...

Hello sir, i have the below data, I want to summarize the data according to Employee id, The employee ID are multiple, i just want that employee id remains unique and its value should adjust like in this form Masters Graduation Diploma 10011614 B.E. / B.Tech.|2021|Rajiv Gandhi...

Hi guys i need some help on VBA. I have range of numbers in Sheet 1 from cells A6:O29. Next i have specific numbers selected in Sheet 3 in Column "B" I want to loop throw each value in Sheet 3 Column "B" and find that specific value in Sheet 1 range "A6:O29" Next it should paste Entire Row...

Autogenerate serial number according cell reference Number ???? I have try cell Reference : A2 =11 i try cell reference A2 to B3 , problem is B3 Cell value According Auto generate serial Number.

Dear All, I would like to Split and assign the splited first the 100 char in one cell. then split the char from 101 to 200 then assign it next cell the splited value via vba in excel. For example: If I receive 1000 char Split 100,100 upto 1000. But the 1000 chars are not fixed. it will be...

Using VBA or excel but mainly vba I have code that depending on number a entered in will make copies of a chart created in excel. I have a formula in a cell in sheet 1 that equals a value in sheet 2. Same workbook. sheet 1 is show below sheet 2 looks like I am trying to use VBA to keep that...

Hi, if i had cell value for example =21+22 answer should be 2 as it has used 2 value in the formula =41+40+41 answer should be 3 as it has used 3 value in the formula now in adjacent cell i need the count of values in that formula <tbody> =21+22 2 =41+40+41 3 </tbody>

Hi guys i have a problem about my userform i have 16 textbox and command button to search in textbox 1. is it possible to search only the last 3 digit number in textbox1 instead of 8? here is my code for my command button :):):) Dim totRows As Long, i As Long totRows =...

<colgroup><col><col><col><col></colgroup><tbody> Table 1: <colgroup><col span="2"><col><col><col></colgroup><tbody> order ID Name Live Date Hours Hours occupied as of today 121 Rajesh 01/19/2019 40 ? 122 Rajesh 01/19/2019 60 ? 123 Rajesh 01/19/2019 20 ? 124 Rajesh 02/16/2019 100 ? 125...

would like to write a program with the below function If Cell ("J" i) or Cell("L" i) or Cell("N" i) in Sheet1 is not empty where i equals to any integer Then cut Cell("B" i) to Cell("O" i) in Sheet 1 to the first blank and rows after that in Sheet2 However,I don't know what should variable...

I'm using a Standard Deviation + If formula: =STDEV.P(IF('Numerical Results'!$A$2:$A$415='St Dev'!A2,'Numerical Results'!$B$2:$B$415)) and have entered using CTRL+SHIFT+ENTER This appeared to be working correctly. I decided to spot check a couple of the results to be sure, so I filtering the...

I have data in a single cell in the below format 1 NULL 384 JPY 0 2 2 384 555 JPY 0 10 3 555 389 JPY 0 128 4 389 1000 JPY 0 2345 I want to split the data into different columns Like for example C1 C2 C3 C4 C5 C6 C7 C8 C9 0 384 555 389 1000 2 10 128 2345 CAn...

Hi, I am working on a problem in which I have an array of start and stop dates (mm/dd/yyyy) and time (24 hour format) and a total cost, for example: Start date Stop Stop Total Cost Row1 3/4/2016 14:00 3/6/2016 08:00...

Hi all This question is related to VBA macro.. How to send automatic outlook mail every day (except sat and sun) at 10:30 am IST using VBA macro Example: To = abc@.com Sub = Reminder Body msg = hi xyz Trade review has been completed for today. what will be vba code for above Scenario ?

Hi all This question is related to VBA macro.. How to send automatic outlook mail every day (except sat and sun) at 10:30 am IST using VBA macro Example: To = abc@.com Sub = Reminder Body msg = hi xyz Trade review has been completed for today. what will be vba code for above Scenario

i have a column containing 1 to 36 representing months(A2:A37) and i have one more cell(M1) in which i am calculating the month by taking difference between two dates. So i want a formula that match M1 with A2:A37 value and based on match i want to add the column values(B2:B37) corresponding to...

Hello Guys, I am recently working on a project, But I met some difficulty while doing it in Excel. Here is the present Format of Data in Excel.. Column 2 has alt enter in it. I don't know how to enter image here so I created link, Please visit Before Format And this is the of Format What I...

Thanks for your support in advance:) I would like to know is there any possibility using IF function with MID to get result ? i am using formula is =IF(MID(A2,1,3)+0,IF(A2<=201,"TT,IF(A2<=202,"MT",IF(A2>3000,"ECT"))) Note! i have three types of ID's (starting id is from 201 & second starting...

Hi Guys, I'am trying to write a small script to delete the "Cancelled" word in a column and keep the "Shipped" and "delivered" words. Below is the code Sub removecancelled() Dim st As String, i As Integer, lastrow1 As Long st = WorksheetFunction.Match("Status", Range("1:1"), 0) lastrow1 =...