Based on criteria, loop through sheets copying rows where cell in variable row is blank

**[email protected]** · 07-09-2014, 12:20 PM

Hello. I need some help modifying some code from one report to build a new report.

I have 29 sheets with a variable list of 400 + rows of data.
In each Sheet range "O1" hold the due date for that sheet.
In each sheet Column "B" hold the Part Numbers.
In each sheet Column "F" holds a completion indicator "X".

I have the following code that is supposed to go into each sheet and
If the due date matches the entry in Cell "F1" of my Delta Sheet
(and ultimately where "B" is not blank & "F" is blank)
Pull in 7 data points.

This is my code so far:

Please Login or Register  to view this content.

I can't get it to do anything past earlier code that does some formatting & creates the headers.

Any help is greatly appreciated. Thank you in advance!!

**Bernie Deitrick** · 07-09-2014, 01:36 PM

You need to be specific about the sheet, and the cells in columns B and F:

Please Login or Register  to view this content.

**[email protected]** · 07-09-2014, 05:20 PM

Thanks for your help Bernie, I really appreciate it!

The code runs but does not return any data???

The headers in the sheet called "Delta Sheet" are in row 4. (I changed "Delta" to "Delta Sheet" in your code)
This should not be an issue as I tell Excel to "Range("A4").Select" prior to your code.

For the sheet named 22M.001 alone there should have been 13 rows of data returned.

Any idea as what we missed?

There are other "things" going on in this workbook - will that make a difference?
Should we limit the code to include only sheets 22M.001 through 22M.029 as the sheets to extract data from?

Thanks again for your help!!

**Bernie Deitrick** · 07-09-2014, 05:57 PM

Post a small example workbook - a lot of times, it can be the structure of the workbook....

**[email protected]** · 07-09-2014, 06:25 PM

Not sure how small this is. I removed most of the data, leaving a lot of the math - so you can see what else is there.

Thanks!

**Bernie Deitrick** · 07-09-2014, 07:46 PM

Please Login or Register  to view this content.

**[email protected]** · 07-09-2014, 08:10 PM

Thanks Bernie. Still won't run though. Even when I run the new code in the sample workbook, it does not return any data.

Thoughts???

Thanks for your effort here Bernie. I really appreciate your help!!!

**Bernie Deitrick** · 07-09-2014, 08:29 PM

I think that when I looked at the date, it converted to a date.

Try this one:

Please Login or Register  to view this content.

**[email protected]** · 07-09-2014, 10:42 PM

Wonderful!! Thanks Bernie it runs great!!

Thank you so much for all your help!!!

Based on criteria, loop through sheets copying rows where cell in variable row is blank

LinkBack

Thread Tools

Rate This Thread

Display

Based on criteria, loop through sheets copying rows where cell in variable row is blank

Re: Based on criteria, loop through sheets copying rows where cell in variable row is blan

Re: Based on criteria, loop through sheets copying rows where cell in variable row is blan

Re: Based on criteria, loop through sheets copying rows where cell in variable row is blan

Re: Based on criteria, loop through sheets copying rows where cell in variable row is blan

Re: Based on criteria, loop through sheets copying rows where cell in variable row is blan

Re: Based on criteria, loop through sheets copying rows where cell in variable row is blan

Re: Based on criteria, loop through sheets copying rows where cell in variable row is blan

Re: Based on criteria, loop through sheets copying rows where cell in variable row is blan

Thread Information

Users Browsing this Thread

Similar Threads

Loop Across Columns...If Blank Cell, Loop Down Rows

Loop Across Columns If Blank Cell Loop Down Rows

Loop through rows and delete based on criteria

Copying and pasting rows based on cell criteria

Copying variable number of rows to new worksheet based on Findit

Bookmarks

Bookmarks

Posting Permissions