lines

Hi all, I am writing a macro which does the following: Looks through a set range by name of the header to the bottom row of the table For each cell in that range if the value is nil, it cuts that row It then pastes that row somewhere else in the sheet - in the next blank row at the bottom...

Hi everyone, Is there a vba that can count the number of rows in an active x text box (I have multi rows selected, I want to know how many there are?) basically if I was writing it in English what I want is Textbox1 number of lines = ??? please help if you can thank Tony

I have a spreadsheet with multiple claim lines per day for various events taking place per customer. I am looking for either a Power Query or Power Pivot solution to show all claim lines for only dates where a particular event took place on one of the claim lines. For example, if customer ID...

Hi Guys, I need to change a multiple line excel sheet to the a single line sheet. I have the below sheet <colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B C J </thead><tbody> 1 Exported On: 16/08/2019 15:40:57 2 #00DC00[/URL]...

Hi Guys I have an excel sheet where a User Name is appearing on multiple lines (See below) And we want it to appear as below

The code I have is following: And the data it is extracting from is this: As you see, the amount of data there might be, varies, but the extract takes a fixed range into account, to cover everything. Now there is a problem, it extracts indeed all the data, but also creates a lot of...

I have a spreadsheet that will have x number of lines added to it. When all lines have been added, I have a button that inserts a signature 5 lines below the lowest part. The lowest part is a line at the bottom. Underneath the line, there is a textbox that will have notes written in it...

I have an active x text box that will not increase in size for extra lines of text that are added. I want it to be a set length, 540 and to increase in size downwards when additional lines of text are added. This is the code that someone helped me with, can someone tell me what I need to...

Hi, I have a need to delete many shapes on a worksheet although I wish to keep others. All of the shapes that I wish to delete are either lines or rectangles and the ones that I wish to keep are not. I had hoped the following would work, but it doess not - can anybody let me know what the...

I have a button to add new lines to my table. The table has a date field in column A that is formatted to Australian date format. When I click the add new lines button, the new lines revert to US format for any dates that are entered in the new rows in column A. How can I force new, added rows...

I have a spreadsheet with a table that is used for storing quotes that has a delete all table lines button. My supervisor needs a way to undo or restore if the delete all lines button is clicked. The quote could be up to 100 pages long, so re-entering all that information is just not practical...

Greetings, I would like to be able to step through lines of code in the Visual Basic Editor, but am unable to do so with F8. My 'F' buttons are set to monitor brightness. How do I locate the shortcut key to step through lines of code, and either reset it or just view current shortcut keys...

I have an Excel question that I am afraid is out of my range of expertise. I have a list of items with inventory values. What I need is either a formula or script that will say if the value is zero, then grab the value from the next line for the same item number if it is not zero, and continue...

Hi guys, I have to make an ERP (by day it looks more complex) like a database in excel with: production type, ok PCs, ng PCs, time and other losses; key machine parts replacing, these parts lifetime; employes's on the shop floor with their leaders; lines, processes; ..... (for abbreviation and...

Hi all. I need Excel to count lines that include the phrase "test & 10", but not to count other lines that only have the word "test" without the & 10 I'm finding that I get zero results for "test & 10" as the keyword 'test' is filtered out in the 1st argument. The formula I've tried is...

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...

I've made a spreadsheet to keep score of a soccer tournament, and I would like to fill the cells if certain conditions are met. To do that I use Conditional Formatting. Doing that I've encountered a very strange problem: Conditional Formatting overrules horisontal lines, but not vertical...

Hello Folks, It's been a long time since my last post and thank you in advance for all contributions that helped me back then. Here's today's question, which for some of you know doubt be reasonably quite straight forward. I have a sheet with data in it (engineers job sheet) Name, Address...

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...

Please can someone help with a script - if column 'O' = .29 then in column 'I' = H/60 if column 'O' does not = .29 then column 'I' = 'H' Then 'J' = 'I' * 'k' The spreadsheet is very long so it should work for all lines in the spreadsheet Thank you