3. filter, then copy/paste values

filter, then copy/paste values

I resorted your table by ComboCode ascending.

QuartCode   DateCode    ComboCode

Q2 04 2022 1078701057040420 Q2 04 2022 1080011074920420 Q2 06 2022 1080011074920620 Q1 02 2022 1084091053280220 match Q1 02 2022 1084091053280220 match Q2 06 2022 1305071076600620 Q1 03 2022 1308441076600320 Q1 03 2022 1308441076600320

With the first two that match (as example), are there other entries that will match too or it is restricted to only two entries?

Once the matches are determined, do you take each match and do some analysis on them for price variance? On another sheet?

Do you need to go to another sheet to do your analysis or could you bring your lookup data to the source table sheet and do the analysis on the table sheet itself?

I'm just trying to figure out what the full process is, I don't have a solution yet, nor guaranteeing one.

/r/vba Thread
Previous
Next

Recently removed from /r/vba

A pseudo block comment method VBA UDF to calculate stock reserves duration in days? Closing another Workbook ends VBA script Looping error Beginner code logic problem Does a Loop with an Arrays have data limits? What have you been working on? (Week of July 19, 2019) Modification of a macro to "mail merge" with outlook Why are my last row and last column references selecting only one cell? Best practices for developing an Excel Add-In (x-post from /r/excel) How advanced are ADODB connections? Clicking a VBA Macro button always brings up the "Go To" (hotkey F5) menu after running. Clicking a VBA Macro button always brings up the "Go To" (hotkey F5) menu after running. Help with running a Macro in Reflection 2011 Help with Macros in Excel

More Random Comments

Monthly "No Stupid Questions" Thread Discussion Chapter 139 - FINAL Kim Potter: Cop Who Shot Daunte Wright Resigns, Flees Home Which song is still stuck in your head right now since you were young? Tourist fans > loyal fans, it's that easy What’s the shittiest way a friend has shown you they weren’t really your friend? BUY BUY BUY What’s the shittiest way a friend has shown you they weren’t really your friend? What’s the shittiest way a friend has shown you they weren’t really your friend? What was the worst display of a sore loser you witnessed ? Karl Heinz Rummenigge: We have a responsibility, towards our fans, who are against the Super League, that we won't forget. And we have a responsibility towards football. Markus Söder akzeptiert Armin Laschets Kanzlerkandidatur Can we get new mods We are prime targets for narcissists, please be careful Viraat Muslims