Automate

Is there a way to use the = and the between operator in a query and have it look in a different sheet?  The information says to enter the cell but does not tell me the format for entering a cell on a different sheet.

I have one sheet I want to return the data to and then I have another sheet for selecting the data.  When I use the in operator I can choose a cell from another sheet, I've tried that same format for the = and between operators and it says it is an invalid cell.

Hi Anita

It looks like you did it for Company already

You would just use the same for the rest. 

Instead of = use IN and then limit it to 1 row  - like this

It will look something like this:

note there was no value in that column, but it would use it if filled in.

You can do the same for fiscal year and fiscal period.

Instead of between for the posting date, I would use Posting Date I'm not sure.  There are relative values, like start of month and end of month, today to today - 7, and the like.  Would any of those work instead?

HTH a little,

Sigrid

Is there a way to use the = and the between operator in a query and have it look in a different sheet?  The information says to enter the cell but does not tell me the format for entering a cell on a different sheet.

I have one sheet I want to return the data to and then I have another sheet for selecting the data.  When I use the in operator I can choose a cell from another sheet, I've tried that same format for the = and between operators and it says it is an invalid cell.

Hi Anita

It looks like you did it for Company already

You would just use the same for the rest. 

Instead of = use IN and then limit it to 1 row  - like this

It will look something like this:

note there was no value in that column, but it would use it if filled in.

You can do the same for fiscal year and fiscal period.

Instead of between for the posting date, I would use Posting Date I'm not sure.  There are relative values, like start of month and end of month, today to today - 7, and the like.  Would any of those work instead?

HTH a little,

Sigrid

Is there a way to use the = and the between operator in a query and have it look in a different sheet?  The information says to enter the cell but does not tell me the format for entering a cell on a different sheet.

I have one sheet I want to return the data to and then I have another sheet for selecting the data.  When I use the in operator I can choose a cell from another sheet, I've tried that same format for the = and between operators and it says it is an invalid cell.