A Macro or VBA coding to filter information from one sheet to another.

[Jet Fusion]

Hi

Thank you to @deciog for getting me this far with my project and now I need macro / coding help to do the below.

Is there a way to make a macro or vba code to do the following, I have uploaded a file with some comments inside.

1. Will it possible (might be taking a chance) to when you select the 49 sheet1 G4 it populates the information on sheet 2 with out having to click on anything on sheet2?
2. On sheet1 G8 - BB32 is it possible to do the same where it extracted the number to sheet2 J16 to do the same when you insert AB5 sheet1 it will where it finds A it will insert "AAA" in sheet2 D11 and the same with D12 it will insert "BBBBBBB" this will depend on the info from sheet1 G8 - BB32?

Thanks in advance
Jet

 

[vletm]

Jet Fusion
based Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

• Use Relevant words in the Title and in the tag Box, This will aid future searches.

 

[vletm]

Jet Fusion
1) It will be possible.
2) It will be possible ...
a) if clear formulas away - solved with code after finds out - what should those do?
b) Sheet1's AB5 is part of merged range ...
c) You should move Your comments as those would be more clear to follow

 

[Jet Fusion]

Hi @vletm

Sorry it may be al litte confusing at first. Would it be easier if I delete all formulas and then make comments on what I would like?

Jet

 

[vletm]

Jet Fusion
Confusing ... what is that? why?
2a) Those formulas result needs to be there, that could compare those with results of coding.
You have there ... 'one data' ... if needs more data ( ... large sheet) then there should be more data with results to see what really needs to do.

 

[Jet Fusion]

Vletm

I have updated the file, I have tried to explain it better for you to understand and see how it should work.

Thanks

 

[vletm]

Jet Fusion
Hint: Question > Answer
You seems to skip two my questions.

Term understand, You should understand this.

From Sheet2:


Sheet2 ... cell M10:
The 1st sentence ... You click something and
later You will input something.
That means slower solution - of course, You can see Sheet2 .. after You have selected it.
Your long writing could be more clear ... gotta check later.

 

[Jet Fusion]

vletm

You did not read the the explanation in the file, it tells you were the information comes from for each section and an example.

The 5 comes from G6 - Like I said there will always be 2 letters and a number.

Where you say it does not match, it just a formating of numbers but the information is still from the correct source.

The only input you will do is on Sheet 1 and populate sheet 2 - nothing will be input by the user on sheet 2.

 

[vletm]

Jet Fusion
You still skipped my questions.
I tried to read as I wrote -
a) There are a lot of same writings
b) Functionality: ... 'when you click' ... that moments values will take care
but after that You continue writing -- will be input by the user D3, D4, D6 and so on ...
... means ...
those possible inputs after Your 'click' do not take care' - no matter what has done - with 2-sheet! (before one more time click range G3:BB3).
c) As well I checked Your comments - FROM SHEET1 G:6:BB30 - and those were different.
eg 1 and 01 are different - for me - no matter of any formatting.
... of course, there seems to be different explanation with Your writings
d) step 4)) Suddenly '3 values in a cell' ... without information - which cell do You refer?
Of course, I could start to guess - but - it would be You duty to give exact information.
e) You're writing something about Filtering ... what would need to Filter? ... there seems to be all rows 'moved' below E14-cell.
> Many things should be clear, before start to write code for someone else. <
= Many things will be possible, as I have written in #2 reply.

 

[Jet Fusion]

vletm

I do not know how else to explain to you and I do not want to waste any more of your time, I would however like to thank you for trying to assit me.

I will continue using the sheet from what I did with @deciog as it works well but would of like to automate it.

This can be concidered as a close thread now, thank you for your time.

 

[vletm]

Jet Fusion
You do not need to explain anything.
You should learn to answer questions.
Questions are sentences which ends with ?
... You should able to write what? how?
Automate ... how that would automate? ... as @deciog has written - it works.
As I have tried to write ... there is 'one column'-data.
If 'click' eg 50 ... then what?
Everything should know, that could write code.
Of course, You could use Your time as You want - but if You have plan to use others time - then answers.