line

I have been asked to spread a series of values over a set number of months that will form a data series that will produce 45 degree line when graphed. Any ideas on the excel formula to calculate the monthly amounts?

Hi We're looking at a basic licensing tool - it's going to be straight forward where someone inputs a licence code (generated from website) which auto populates a single line confirmation. I'm trying to see how I'd add this single line into a excel cell somehow, and then work with the string...

cross post : https://stackoverflow.com/questions/57824008/excel-automation-with-ie-execute-macro-code-while-waiting-for-other-applicatio Error prompt : Microsoft Excel is waiting for another application to complete an OLE action I not looking for way to prevent that prompt coming . but i...

I have three data tables (see below). The first one (A1:H12) shows the employee name and whether they are in work on a given day The second one (J1:P12) shows what job role they are working on a given day The third one (R1:X12) shows what line they are working on What I...

Hi, I have got here a very simple macro that copies three values to a worksheet from a userform and then it opens a new email message and it pastes these values into the email message. The userform has 3 text boxes and 1 command button: TextBox1 TextBox2 TextBox3...

Greetings, I have a I column of values of the format " Aug 30, 2018" and so on. I would like to be able to convert these into the format "MM/DD/YYYY" Dim A as Long, LastRow as Long LastRow = Cells(Rows.Count,"A").End(xlUp).Row For K = LastRow to 1 Step -1 CDate(Cells(K,"A").value) =...

Please could someone advise me how to do this ... I am using an array formula which I found - however, I need it to sum upwards and not down The formula is =SUM(A1:INDEX(A1:A3000,MATCH(TRUE,(A1:A3000=""),0))) I need the total 682.20 to be on the green line, the total 191.20 on the next green...

Hi I have a workbook that has approx 12,000 entries but im trying to copy and paste into a new workbook but avoid line 1. At present im having to highlight all the data from line 2 onward down the page and copy and paste into new workbook. Is there any easier way I can copy and paste...

Hi experts, I have a long list of data exported into excel from a text file. This file contains output of a command from multiple network elements. Whenever there is a text string 'Welcome to', the below mentioned text should be copied to a new column till the next 'Welcome to' appears. In this...

I have a line graph that shows the credit rating on a business over the course of the last 12 months. Is there a way to highlight a specific date in the time line other than insert shape?

Hi I have a spreadsheet running vba which separates data into the relevant tabs. my problem is after running the macro, if i need to correct a line in the master sheet it doesnt update or create a new tab. So for instance, tab 2 has 2 lines of info, i then go to the master sheet and edit 1...

Hi all, I have hit a problem with my work project and it's one of those where I can't even begin to design the solution never mind implement it! I hope you guys can help! I have provided a sample workbook here. https://drive.google.com/open?id=1u30oLh9SavbDpc3YVfoWGCEGJZ7Aqpeu The process...

Hello, people, Wow. This forum sure makes it difficult to show a sample spreadsheet. And I've read posts complaining, but that rule apparently ain't gonna' change. Ah, well. OK. I've done a lengthy search, found many people with the same problem, but no answers. How, in Excel 2007, to...

Hello all, Is it possible to create a line chart with points of interest? Let's say I use this data: <tbody> Day Bookings Event 1/1/2019 78 2/1/2019 320 HH Mailer 3/1/2019 160 4/1/2019 290 JV2 Mailer 5/1/2019 300 6/1/2019 140 7/1/2019 230 WE Email </tbody> So I'd have a...

Good afternoon, I want to give line number of reading subject for my students. Paragraph-LineNo-para No-total lines-start no. 1-1-1-5-1 1-2-2-4-6 1-3-3-2-10 1-4-4-3-12 1-5-5-6-15 2-6-6-9-21 2-7-7-4-30 2-8-8-4-34 2-9-9-3-38 3-10-10-3-41 3-11-11-3-44 But now I just carry them by key the number...

Hi, i have made a very simple linechart, with Months on the horisontal axis, but as data for the months august-december has not materialized, the line chart makes this annoying break at the last month with data (juli) , how do you make the line just stop at the last point of data? Kind regards...

Hi everyone, I am trying to create a report that pulls through data with more that one line when a certain criteria is selected from a list. For example if I select a country I want it to pull through everything that is against that country. I tried a basic lookup but that only pulls through...

Hey guys, can someone tell me please why this file is not working? https://sheet.zoho.com/sheet/editor.do?doc=2f316a5f957451ed09ebbb4a127947ccf5a1467f845cffe4c8a8094a66592afeb433327fda0a94208330b6f8e188e67294c4ed9a2e62d8dd325f910d1a209e47 am using (...

Hi, I am trying to write some vba code which will allow me to look to see the value of a cell, if that cell = X then display a msgbox "cell = X, are you Sure?" with options yes or no. If they click no then it exits the sub routine. If they click yes then the code continues onto the next line...

Hi i have a big ledger in excel. In column E i have account numbers on each line + a lot of more info. To make a working pivot table i need to delete many lines containing some of the account numbers. This is the ledger: 1: Bilagsnummer; Bilagsår; Bilagsbeskrivelse; Dato; Konto; beløp 2...