have to find all PENDING ORDER from 9 work sheets in same workbook

[zoharb]

Hi ,
have to find all PENDING ORDER from 9 work sheets in same workbook
Zohar Batterywala

 

[zoharb]

Respected Sir ,
I think the problem could be this -hrs count after "pending"
Zohar Batterywala

 

[zoharb]

Respected,
recently I tried to save the XLSX file and it mentioned me to SAVE in XLSM.
If I save it in XLSM, will other formulas of VLOOKUP, XLOOKUP, UNIQUE(made in 2021 version) will work. And it will allow to use for normal data entry??
Zohar Batterywala

 

[mumps]

Do you want to include the rows which contain -hrs count after "pending"?
You must save the file with an "xlsm" extension because the file contains a macro. This will have no affect on other formulas.

 

[zoharb]

"There are easier ways to run macros such as clicking a button on your sheet or a letter of your choice on the keyboard. If you are interested in this approach, please let me know."
Yes

 

[mumps]

Do the following to insert a button:
-In the menu at the top, click on INSERT.
-Click the SHAPES button and the select a shape such as a rounded rectangle.
-Click on your sheet to insert the shape.
-Move the shape to your desired location on the sheet.
-Right click the shape and click EDIT TEXT. This allows you to enter a label for the shape.
-Right the shape and click ASSIGN MACRO.
-In the pop up, select the CopyPending macro and click OK. When you click the shape, the macro will run.

Do you want to include the rows which contain -hrs count after "pending"?

 

[zoharb]

Do you want to include the rows which contain -hrs count after "pending"?
You must save the file with an "xlsm" extension because the file contains a macro. This will have no affect on other formulas.

sir, what to change in the code?

 

[mumps]

If you want to include the rows which contain -hrs count after "pending", then there is no need to change the code. If you want to exclude the rows which contain -hrs count after "pending", please let me know and I will change the code.