Retrieving the data of the target number from a closed book

[Tacir]

Hello my Excel masters


We have a closed book.We constantly record the data in that book.Formats column headings are fixed.

Can we call the data of the relevant target number from a closed book to our open Excel book?

I wanted to explain it as much as I could in the Excel book.


Thanks in advance

[windknife]

Try this in F2, then copy down and across.

Please Login or Register  to view this content.

[Tacir]

I guess I couldn't explain

B column numbers are fixed on the main page (L.Number)
If the number in column B (L.Number) is in a closed book, those marked including the L.number will be brought to the main page.

We need to do it as shown in the picture.

[windknife]

Did you input previous formula in MaskerK!F2, then copy down and across?

[Tacir]

I couldn't explain much due to language requirements.


On the home page (if there is L.Number)
We want to pull the data from the yellow columns in the closed book
In the yellow column locations on the master page

formula brings gender

[windknife]

It's weird. I saw is correct. Please see the attached file.

[Tacir]

The column count formula messed things up.
it worked now

columns =sütunsay

excel automatically translated your formula

Can't we do this formula with code? this formula worked
like automatic formula filling ?

[windknife]

You can wait someone to write a VBA code.

[Tacir]

but the formula was nice

[windknife]

I'm glad to help.

[Tacir]

When I searched the forum I found a code from Mr. Jindon

https://www.excelforum.com/excel-pro...ive-sheet.html


I tried to design it in my own file.I can more or less interpret the codes.
But I made a mistake somewhere and I couldn't run it.

Can you take a look at the relevant files?

Calling the relevant data of the number from another closed book

[windknife]

Try this,

Please Login or Register  to view this content.

[Tacir]

windknife

This is it!.Mr. Jindon's codes became our map.

Thank you very much for the effort you put in.I hadn't thought about the last code sentence at all.

Both options turned out very well. Formula and coding

Very nice thank you

[windknife]

You are welcome.
--------------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.

[Tacir]

I was waiting to bookmark it after your comment.

I added your reputation before.

It is now marked as solved.

[Tacir]

Windnife,

(L.Number) The code gives an error when alpha is numeric.

I hadn't thought about this part.


example , L.Number 40-D-702 if it happens

There is no problem when there is a number


f1 =

Is it necessary to use similar function instead of equality?

[Tacir]

rs.Open "Select F1 , F2, F3, F4, F5, F6, F7, F12, F9 From `Summary$a2:o` where F1 like '" & .Cells(i, 2) & "';", cn, 3, 3, 1

I think I fixed it

[JEC.]

Here a variation (In your current method, you are reloading the two objects in every loop)
You don't need a loop.

Please Login or Register  to view this content.

[Tacir]

Dear Jec,


Thank you for your information and interest.

I add your solution to the module

[Tacir]

Dear jec.


Alpha numeric ones still seem to be a problem

[windknife]

Try this,

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

[Haluk]

Alternative;

Please Login or Register  to view this content.

Sample workbooks are also attached and be aware that, some of the headings are different (misspelled) in the workbooks such as "Diagnosis" in the master WB and "Dianotics" in the other WB.

[Tacir]

Thank you very much for your efforts . Dear Jindon and Dear windknife.


Master Jindon's sample codes were the beginning of the topic and it ended well.
Adding your reputations is a duty

Kind regards

[AliGW]

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

[Haluk]

@Tacir;

Did you also try my attached workbook ?