Excel - macro to loop through row data and copy cell to each worksheet in the workbook

**swilson2006** · 11-20-2013, 12:35 PM

Hi

I hope someone can help. I am looking for a macro that can loop through column A and look for the the cell value beginning with "275X" and then copy the cell values in column A to each worksheet in the workbook.

So if column A has 275X105 in A6 and 275X112 in A7 then worksheet 2 cell B3 should be updated to say 275X105 and worksheet 2 cell B3 will have 275X112 and so on and so forth.

Many thanks all in advance.

S

**hamjam** · 11-21-2013, 06:04 AM

Hello
Your destination seems to be the same place. Do you rather mean 275x105 in sheet 2 and 275x112 in sheet 3 ?
Is it always the same cell (B3), just on a new sheet
What if there are more 275x values then worksheets ?
Is the order sequential, i.e. 1st matched value is copied to sheet 2; 2nd value to sheet 3, etc.

Regards

**JOHN H. DAVIS** · 11-21-2013, 07:54 AM

Not sure I understand. Does this help?

Please Login or Register  to view this content.

Excel - macro to loop through row data and copy cell to each worksheet in the workbook

LinkBack

Thread Tools

Rate This Thread

Display

Excel - macro to loop through row data and copy cell to each worksheet in the workbook

Re: Excel - macro to loop through row data and copy cell to each worksheet in the workbook

Re: Excel - macro to loop through row data and copy cell to each worksheet in the workbook

Thread Information

Users Browsing this Thread

Similar Threads

Macro to copy specific cell data into a different excel workbook

Macro Copy/Save active worksheet into a pre-existing workbook & rename sheet to cell data

Copy cell data within workbook to a different worksheet

Macro to copy data from worksheet (name changes daily) to master workbook

loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook

Bookmarks

Bookmarks

Posting Permissions