repeat

Hello, I am trying to delete blank cells to the right of Column E, until its filled with value "BU" or any value really I need to a loop that goes to the last row. So if G2 has BU, then look at E2, No value, then delete, move left, repeat, until E2 has BU Can you help please. Ross Thanks Ross

Hello, I want make a calculation and if negative to make it zero, while if possitive to leave it as is. I write it as: []=IF(($D$123-D30*$D$10/$D$21)>0,$D$123-D30*$D$10/$D$21,0)[] Is there a way to make it shorter without having to repeat it twice in the formula because it gets very long...

Hello I download results from multiple searches using a loop, but in some cases website reads your search time out. However if I manually re do the search it works. So, I would need to re-do or repeat the same search and then continue as usual. I would like for the code to re-start the...

Hi, I have a huge excel data which I need to compare the same Part # with same Ref # and add the "First" or "Repeat" in Remarks column, according to the Date. Below is a sample: <colgroup><col width="129" style="width: 97pt; mso-width-source: userset; mso-width-alt: 4579;"> <col width="181"...

I'm working in Excel 2016. I have the following typed into a merged cell 11/5 to 11/9/18. I want this information (11/5 to 11/9/18) to repeat in other cells instead of typing it over multiple times. I used the formula =CELL("content",a1), however this is bringing back the result of #VALUE ...

Hello and thanks in advance for your help, I have a database of roughly 5,000 companies with 20,000 lines of data, with the company data stacked vertically vs horizontally. Each company is shown as follows... Company name Street address City, St Zip County I need each company's...

Hi, I've made this code for one row, and want to repeat it for the next 200 rows or so. Any tips? Dim d As Double d = Range("H10").Value Range("H10") = d + Range("J10").Value d = Range("I10").Value Range("I10") = d + Range("K10").Value Range("J10").ClearContents Range("K10").ClearContents

Hi, Please help.. I am having trouble finding right code for my project. There are three rows. The third rows is empty. I need vba to evaluate B1, if less than 0, put an X in C1. Repeat on down until there isn't a value in column B. <colgroup><col width="44" style="width: 33pt...

Hello, I am trying to work my way through a script that will take information from one column, concatenate it with another, repeat that for a section of cells, and then repeat all those steps with a different original field, incrementing until a blank field is reached. The data I have looks...

Hi, I am using the formula below which works great - up to a point. After 21 cells it just repeat the last cell details. Anyone who can assist please. {=INDEX($R$353:$R$498,MATCH(SMALL(IF(COUNTIF($U$402:U403, $R$353:$R$498)=0, COUNTIF($R$353:$R$498, "<"&$R$353:$R$498), ""), 1)...

Hi, I was wondering if there was a formula that could automatically duplicate the first KeyLetter for each row until it changes then repeat? ITEM LETTERKEY LETTERKEY DUPE Item 1 A A Item 2 A Item 3...

Is there a possibility to duplicate cell entry in another sheet? Say I enter columns A:H in worksheet 1 In column B I have a drop down that lets me select MTI, LTI, FAI Based on each of this selection is there a possibility that if MTI is selected that in worksheet 2 column J is updated The...

Good Day, I have a spreadsheet which contains names in column A sorted alphabetically. And after a certain row the names start to repeat. I'm trying to write a macro which finds the row where the names start to repeat, then deletes that row and all subsequent rows below. Can anyone help?

I have a working QR code generator that works for one page put now I want to have this QR code populate cells in another worksheet. the code is in QRTemplate worksheet and the second worksheet I would like to have the QR code Generate is QRLabel worksheet. The code is: Private Sub...

Hello, I'm new here and I'm must confess I'm ZERO in VBA. But I like the challenge to learn for some more. I need to create a table (table 1) from another table (table 2 in different sheet) in which a specific row (row1) from table 1 will be copied and pasted to table 2 a number of times as...

Hi all, I am setting up a calendar / planner on excel at the moment and I need the exact same text that I have typed into the first sunday cell to repeat on each every other sunday cell but at 9 weekly intervals. Anyone any ideas? Much Appreciated

Hi, I'm trying to create an array (which will be ultimately used in a formula e.g. NPV) of cell references which repeat themselves (which will be dependent on another cell reference). The range of cell references to be repeated will also be dependent on another cell reference. Sorry if I didn't...

I just yesterday experienced a very odd printing error where my pivot table report would look fine in the Print Preview but when I print it, it doesn't actually print anything; it just spits out 2 blank sheets of paper. After trying another report and making a few modifications here and there...

Greetings, Context: I have three tables (formatted as tables) with the same data going into them. Each table has different formulas for calculating different things. Duplicates from each table are removed differently, to accommodate different reports, which is why there are three (in case you...

Hi all - I apologise in advance if I sound stupid. I would be very greatful if someone could tell me how to repeat the following macro multiple time to look at other columns..it if K populated put date in L, if N populate put date in O etc... Private Sub Worksheet_Change(ByVal Target As...