How to copy certain value from one sheet to another

[amr7]

book- 1.xlsx

Hi all

I just want to find formula for this problem

I have sheet that contain all the journal entries and I want to copy all salary entries in the salary sheet.

What is the suitable formula to do that

[6StringJazzer]

Your "Sallary" sheet (should be "Salary") is blank. What do you want the result to look like?

[amr7]

I want to get all amount of salary only from journal entries sherrt which contain all enteries

[FlameRetired]

Try array-entering this formula in cell A2 of the Sallary sheet. Then fill downward as far as needed and across.

Please Login or Register  to view this content.

Array enter means the formula must be committed by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

I copied the corresponding headers to the Sallary sheet as well. The file is attached.

[amr7]

Thanks for your great efforts

can you please explain in more details how I can copy this formula

[FlameRetired]

Yes. The formula "box" (in post #4) has a blue icon in the upper left. Click that. It selects / highlights the entire formula. There is a white icon next to the blue one. Click that to copy the formula.......or hold down the Control key while hitting C (the keyboard shortcut for Copy).

[amr7]

and how I can paste in the excel sheet

[FlameRetired]

Select cell A2 in the Sallary sheet, click in the formula bar and paste there (Control + V is the keyboard shortcut); then commit the formula by pressing and holding Ctrl + Shift while hitting Enter. Then fill across to column F and down till you get blanks. (Your data only returns one row so far.)

[amr7]

390659-how-to-copy-certain-value-from-one-sheet-to-another-salary-filter.xlsx
I face another problem now, when I change one of the parameters(I want to extend the range of journal entries), the result of formula completely changed
plz check the attached sheet

[FlameRetired]

Attachment 390843
..................when I change one of the parameters(I want to extend the range of journal entries), the result of formula completely changed
plz check the attached sheet..................

That is what it is supposed to do when you change parameters or extend the range of journal entries, but I noticed on your recent upload not all formula had the {} curly braces around them (those indicate correct entry of array formula) and not all formulas were addressing the same cell rows.

In edit mode if you commit the formula that is in cell A2 (with its new range 'Journal Enteries'!A$2:A$99) by pressing and holding down Ctrl and Shift while hitting Enter you should see those {} braces around your formula in the formula bar. Once that is done fill that formula down and across as far as you feel the need. Those {} will be in all of the formulas.

The attached file shows what I am referring to.

[amr7]

Thanks a lot FlameRetired for ur help and advice, i got it and it works now

[FlameRetired]

You're welcome...glad it works and thanks for the rep.

And BTW thanks for marking this thread [SOLVED].

[amr7]

can you briefly explain how this formula working