looping a macro

Hi Masters, I can't figure out on how to complete the procedure. Below is the full code of what I am trying to do. After the set of these code below when the condition is met in my 1st loop, THEN on the 2nd loop it will overwrite the data copied and inserted on the 2nd row. The 2nd loop should...

Good evening friends, everyone I have a worksheet where the URL List is filled in range A and the URL worksheet has been prepared, I want to retrieve the data for Price and Stock. I want all the data in the Worksheet List I can take for Price and stock only. Errors occur when running the...

A supplier requires me to send them in an individual form(excel workbook) for each of my customers in order to receive a rebate on my sales. I have added a list of data on a separate worksheet to the "rebate workbook". The data columns are Customer Names, Account Numbers, Sales Volume and the...

Hello guys, I've been struggling to write this for days macro and I have finally decided to ask for your help. Here's what I have: Sheet1 - Job IDs, Assignees and Tasks as headers A1 - IDs B1 - Assignees C1 - Tasks *Rest of the columns are something i've tried which did not work...

Dear Sirs/Madams, I have a code which search for a specific text 'PEN COLOR' in column 2, select that cell and 1 cell to right, then cut the selection and paste 1 cell right to the same row. My code works fine for small amount of data ( or rows (around 1000 rows), but when it goes for large...

Hi All, Every month I have this task of collecting data from about 200 reports, into a main central consolidation file. The Report is an Excel file stored on SharePoint. All the Data i need is on a hidden tab in one Range. Process:- 1. I go to the SharePoint site where the files are stored and...

Greetings, I will get directly to the point. *What I Have. 1)-I have one folder which contains multiple excel workbooks. All of them are in .xlsx format. 2) Each workbooks has multiple worksheets 3)The important sheet for me is the first one of each workbook, which has a dynamic name i.e. the...

Hi, I have a project where I need to copy select cell values from 200+ sheets into One sheet (Kind of like a report). The cell numbers are the same across all worksheets, I managed to get the copy portion to work but its only running it on one worksheet, for some reason its the last sheet...

I have a macro that calculates a sheet, waits 1 second, then does it again. After 12 seconds, it switches to the next sheet and does the same thing. I'd like the macro to run certain number of times, based on the value of a cell that the end user inputs into a box. I've minimal experience with...

I have a vba code to get info from multiple workbooks then paste them consecutively in one worksheet. I want the macro to paste to cell A1 everytime i run the macro, after clearing contents of the previous time i ran it of course. But instead it pastes to the last cell used from the last time i...

This Macro is used to cut, insert and delete a cell range section of a workbook. The problem I was trying to solve and gave up with the lack of response in another thread is why copying multiple non-adjacent rows to the MS clipboard often loses their row line-breaks when pasting. E.g. Since...