starting

Hey, looking for some help with a code that will copy a range of data and paste x numbers of times depending on what value is selected. In addition I would need column A (starting in A8) reference how many times the data set was copied. Thanks in Advance Drop Down Box: B1 Range of Data...

Hello experts! I collect information submitted by local constituents using an excel form. I would like automate the tallying of information collected on tabs that may be inserted into the excel form (copies of the tab Part II-SubContracts) using VBA. I will also need to share this macro with...

Hi all, I would like to ask for your help. I have the following text in cell B2: 'John Smith' and I need to get only OHN starting from the left. I've tried using the =LEFT function but it gets JOH but I need to get OHN. Thank you excel pros.

I need to refine this part of my code, I was thinking maybe as an IF statement, So if dd(1) = "@" then data is pasted into sheet1 column A starting at row 2 dd(2) = "http:" or "https" then data does into sheet1 column B starting at row 2 Problem is the (2).innerText and (3).innerText can...

Hi I’ve got a column of numbers starting in N4 for example 7 1 25 22 34 30 In the next column starting in O4, i’d like to place them in ascending order 1 7 22 25 30 34 I can’t work out how to do this. Any help is very much appreciated. Regards

Hi: Column O 200 600 510 Column P 51015150 50812500 10001000 20001000 10325450 I am looking for a formula: If O12=200, 600, 510 "do not tag", if (left(P12,3)=510, 508, 103, 1*, 2*, "not not tag","tag" 1* are numbers starting with 1 2* are numbers starting with 2 Could you help please...

I have 2 columns A and B In A there are 20 dates that get larger as you go down starting on 20/12/2018 but not necessarily by 1 IE 20/12/2018 then 01/01/19 then 02/01/19 then 10/01/19 then 15/01/19 etc) In column B there are 20 numbers starting from 1 and ascending but again not increasing by...

I would like to find the first empty cell on a worksheet after I define a starting point for the range. Here is where I am stuck: Rng = Sheets("Sheet 1").Range("X:X") For Each Cel In Rng If Cel.Value >= 50 Then Rng.Offset(, -21).Copy 'Paste to cell on...

Hi I have cells J2 (start time) and K2 (finish time) I need to calculate the time elapsed between the two cell values in hours and minutes but some will be start AM and finishing AM but some will be starting AM but finishing PM. The format of the start/finish is h:mm AM/PM Any help would be...

Hi Everyone, I need a macro that runs macro "Do the Ds" if someone clicks in the the range "D12:AXY1500" and the cell contains text starting with the letter "D". keep getting errors please help if you can Thanks Tony

Hi all, Do you know if there is any way (without using VBA) that I can get the graph to change depending on the value entered into cell E2. A4 will always be the starting cell data for the graph, but the graph will take more days into consideration the higher the value in E2. Thanks

Hi everyone, I need a VBA code that would merge every three rows (if data exists) starting from row 2, and covering column range of A to lets say J. Many thanks in advance,

I'm trying to build a financial report that automatically pulls in data based on a date range...but the date range can change. For simplicity, let's just use 'years'. Here's what I have: A1: 2019 (this is the starting year) A2: 5 (this is the number of incremental years I'd like to view)...

I have multiple daily sheets that are named by date starting at 01012019. I have another sheet that is named MovingLeaving. I am looking for a way to update one cell value on the daily sheets starting from a date on the MovingLeaving sheet and I need that value to update on every newsheet...

I've tried a few things and nothing seems to work. Let's say A1 = a number input by a user. What I want to put in cell B1 is, sum the number of columns from left to right starting in column C1 based on the number in A1. This formula would be row based - so it would only sum C1:F1 if A1 was...

Hello, I have a list in E2:E10 that has some blanks. How can I return a non-blank list starting in E12? Thanks for the help, XJ

Hi Ive got the formula of =INDEX($BA$1:$CT$1,ROWS($A$6:A28))&" "&INDEX($BA$2:$CT$2,ROWS($A$6:A28)) which I believe takes the data from cells BA1-CT1 and also from BA2 to CT2 and works it way down the rows on a page. What Im trying to do is get the data starting from BA3 and copy all the...

Hi, I have several hundred .xlsx files with data I want merged into one file. * Only .xlsx files * Sheets("Sheet1") * Data is in A:F starting at row 2 Best way to approach this? Files are all under 100kb and contain roughly 2000 rows in each Appreciate any help

Hello, Here is my problem. I need a formula solution for this. NO VBA. I have a single column (A:A) large (around 70000 rows, distinct) data. From that data, I need to extract some of the rows to another sheet based upon the starting and ending cell values. Here is the example for problem. In...

Hi All, I have a macro which run automatically at a specific time which connect SAP and run the SAP script. The input of the starting date is expected to enter the current date deduct by 7 days. Below is the code which the starting date need to be specified a date. I am not able to use...