loop and copy

Hi, I'm having trouble coming up with a way to create a code in VBA that would parse through a table of data, recognize if a value was in between a set of numbers and if it was, copy and paste the row into the next avaiable empty row in the new sheet. Then, if all went well, it would go down to...

Hello! I've been stuck on this one task for a while now and I was hoping to get some help. I currently have a spreadsheet of data ranging from A1:AF60, some of which are in BOLD text. I need to loop through each cell in the entire spreadsheet and select the entire row if that row contains a...

Hello, After spending too much time on this problem, I am hoping to find some help here - seems like the right place. This is the last bit of code out of a larger macro - which (except for this bit) works fine. I have one dynamically changing column - i.e. a column within which Solver loops...

Hi All, I'm a VBA beginner I would like to copy text from a webpage that is not in a table. The text is basically a daily post from this calendar year. The individual page URLs have the date in the URL. For example, these would be the pages from the first 4 days of March...

Can someone get me pointed in the right direction on creating vba to loop through folders and subfolders to copy/paste data from a specific cell in multi-worksheet workbooks? The cell is in the same place in all workbooks and is a named range/cell (jobnumber). The workbooks have a standard...

Hi, I'm pretty new to VBA and desperately need help! I have to loop through a column of data, select only the visible cells in that column, extract the left seven characters then paste them into an external workbook I've already created. This data will be pasted on sheet2 of the external...

Hi, I want to run the loop backwards in order to search a string. The requirement is as below: <tbody> A B C A1 game A2 ZOK name A3 pen A4 mobile A5 KUY copy A6 shirt A7 rat A8 mat A9 hat </tbody> I want to copy the rows from one sheet to another based on the...

Hi, I am trying to loop to check email addresses in column 1 of sheet4 against those of sheet2 in col 6. If found I need to copy corresponding info from sheet2 to sheet4 and then I am done with that email address from sheet4 and need to attempt the next one from sheet4. If not found continue...

What would be a good way to increment each of my ranges for example I need x to copy Range B11:to G20 and paste it to C10 for the second loop. Each Variable has different increments. Any Help is appreciated cause I'm horrible with Visual Basic. Sub Macro5() ' ' Macro5 Macro ' Dim i As...

<TABLE style="WIDTH: 748pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=995><COLGROUP><COL style="WIDTH: 27pt; mso-width-source: userset; mso-width-alt: 1316" width=36><COL style="WIDTH: 218pt; mso-width-source: userset; mso-width-alt: 10605" width=290><COL...

Hello! I'm a little bit frustrated because this macro is not working. Good thing is that I'm not receiving an error message but it is not working. I need to change the cell value of the information of Sheet 1 to the cell value of a conversion table at Sheet 2. Sub ChangeName() Dim h As...

Hello, Kind of new to macros. My problem: I have a long list of data (say 14000 rows with data from A:E). There are 20 sites reporting data for 700 measures. (For whatever reason the data is sent to me in list format). I am not sure of the best way to proceed but I am thinking that a VB...

I have a macro that I need to loop through all of my data until there is an empty row or it hits row 9 (whichever comes first) in the first column and then start over in the next row until it reaches an empty cell in row 1. The reason that I can't have it just go through 9 is because I dont want...

Hi Guys, I'm pasting values from one sheet to another based on multiple named ranges. Woks great when pasting one column but when i add multiple ranges, UFFF!... Read below... General Overview: I have a sample workbook attached, there are (2) sheets of importance. First is the sheet...

I have data in one tab ("Country") organized by columns: Col A Col B Col C Col D Col E Col F Italy Euro Prod1 Cost Date ROW Italy Euro Prod2 Cost Date ROW Spain Euro Prod1 Cost Date ROW Italy Euro Prod3 Cost Date ROW I want to loop through the range...