VBA Find Characters in String, Locate Value in Another Column, Validate Value in Another Worksheet

jski21

jski21

Board Regular
Joined
Jan 2, 2019
Messages
165
Office Version
  1. 2016
Platform
  1. Windows
Good morning Mr. Excel Team,

I'm finding myself doing a loathsome repetitive monthly task that begs for automation but not sure how to even get started and am looking for some guidance.

I'm seeking a way to lookup the three characters in Column U--beginning in Cell U6--in another worksheet, find a value in a specific column, compare that value to the value in Q6 and if it matches, display "OK" in V6. If it doesn't match, display "ERROR", and if it's not found, display "NF". Then move to the next row in column U (U7) and perform the same operation which would continue until there is no more data in column U. Here's the workbook with the data I'm trying to validate:


Book to Validate.xlsx
ABCDEFGHIJKLMNOPQRSTUV
1RES SALARY COMMITMENTS FROM: RES SAL SHEETOPR396510SALARY COMMIT DATA FROM SALARY FCST WKBK. NOT ENTERED HERE.
2RES NON-SALARY COMMITMENTS FROM:FUND99001R&T
3Recon Dateto be addedYTD Only
41234567891011126 Mnths Remaining
5CATEGORYEXPENSE CLASSPROJECT BUDGET PRIOR YEAR SPEND July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June YTD EXPTTD EXPCOMMITMENTSTOTAL FCST EXPENSEEXPENSE CLASS
61 Control511$ 32,916$ -$ -$ -$ -$ 18,492$ 18,492$ 18,492$ -$ -$ -$ -$ 88,392$ -$ (18,368)$ 70,024511 OK
7SUPP STAFF512$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -512 NF
82 Control513$ 11,345$ 11,345$ 11,345$ 11,345$ 12,075$ 29,500$ 10,332$ 10,332$ -$ -$ -$ -$ 107,618$ -$ 70,374$ 177,992513
93 Control514$ -$ -$ -$ -$ -$ -$ -$ 131$ -$ -$ -$ -$ 131$ -$ (131)$ -514
104 Control515$ 15,000$ 24,547$ 22,083$ 22,083$ 22,383$ 22,383$ 22,383$ 22,383$ -$ -$ -$ -$ 173,247$ -$ 91,753$ 265,000515
115 Control516$ 23,284$ 41,869$ 5,743$ 18,243$ 18,243$ 18,243$ 18,243$ 18,348$ -$ -$ -$ -$ 162,215$ -$ 58,125$ 220,340516
12TECHS517$ -$ -$ -$ -$ -$ -$ -$ 940$ -$ -$ -$ -$ 940$ -$ (940)$ -517
13LECTURER51A$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -51A
14FRINGE BENEFITS51Z$ 20,239$ 18,597$ 7,791$ 11,291$ 11,580$ 20,160$ 17,871$ 18,164$ -$ -$ -$ -$ 125,692$ -$ 68,276$ 193,96851Z
15TOTAL SALARY & FRINGE$ -$ -$ 102,784$ 96,358$ 46,962$ 62,962$ 64,281$ 108,778$ 87,321$ 88,790$ -$ -$ -$ -$ 658,235$ -$ 269,088$ 927,323
16FRINGE APPLIED TO BUDGET529$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -529
17GENERAL SUPPLIES531$ 41,562$ 24,051$ 15,922$ 25,303$ 36,591$ 64,527$ 57,185$ 49,576$ -$ -$ -$ -$ 314,718$ -$ 208,500$ 523,218531
18INTERNAL SVCS.532$ -$ 7$ -$ 58$ 206$ 84$ -$ -$ -$ -$ -$ -$ 355$ -$ 400$ 755532
19OUTSIDE SVCS.533$ -$ 672,497$ -$ 443,603$ 126,130$ 169,617$ 1,204,721$ 264,253$ -$ -$ -$ -$ 2,880,821$ -$ 3,571,700$ 6,452,521533
20TRAVEL & RELATED534$ -$ 164$ 2,268$ 3,738$ 392$ 540$ 1,737$ -$ -$ -$ -$ -$ 8,839$ -$ 26,600$ 35,439534
21COMM. AND SHIPPING535$ 20$ 59$ -$ -$ -$ 62$ 95$ 17$ -$ -$ -$ -$ 253$ -$ 600$ 853535
22EQUIPMENT536$ 1,934$ 159,673$ 168,087$ 13,200$ -$ 2,406$ 22,739$ 7,629$ -$ -$ -$ -$ 375,668$ -$ 100,000$ 475,668536
23RENTAL CONTROL537$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -537
24EXPENSE ERROR539$ 147$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 147$ -$ -$ 147539
25MAINT. MATERIALS541$ -$ -$ -$ -$ -$ -$ 262$ -$ -$ -$ -$ -$ 262$ -$ -$ 262541
26MAINT. REPAIRS543$ -$ -$ 789$ -$ 414$ -$ 110$ -$ -$ -$ -$ -$ 1,313$ -$ 1,200$ 2,513543
27INTERNAL FUNDS TRANSFER550$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -550
28INSURANCE 551$ 609$ 614$ 614$ -$ 1,228$ 614$ 3,823$ 1,911$ -$ -$ -$ -$ 9,414$ -$ 4,000$ 13,414551
29TAXES & LICENSES555$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -555
30GENERAL MISC556$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -556
31SCHOLARSHIPS571$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -571
32AID572$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -572
33PRIZES & AWARDS573$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -573
34RESTRICTED CTRL581$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -581
35BILLINGS582$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -582
36OVEREXP SAL583$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -583
37SUPPORT DISC584$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -584
38SALES588$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -588
39OTHER DIR EXP599$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 50,000$ 50,000599
40BOTTOM LINE BUDGET$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -
41TOTAL NON SALARY$ 44,272$ 857,065$ 187,680$ 485,902$ 164,961$ 237,850$ 1,290,673$ 323,386$ -$ -$ -$ -$ 3,591,789$ -$ 3,963,000$ 7,554,789
42DIRECT COST TOTAL$ 147,056$ 953,423$ 234,642$ 548,864$ 229,242$ 346,628$ 1,377,993$ 412,176$ -$ -$ -$ -$ 4,250,024$ -$ 4,232,088$ 8,482,112
43$ -$ 560,388.03$ 1,553,923.46
44INDIRECT COST538$ 84,391$ 86,616$ 40,384$ 74,448$ 78,148$ 109,102$ 123,160$ 104,483$ -$ -$ -$ -$ 700,732$ -$ 341,837$ 947,893538
45$ -
46GRAND TOTAL$ 231,447$ 1,040,040$ 275,026$ 623,312$ 307,390$ 455,729$ 1,501,153$ 516,659$ -$ -$ -$ -$ 4,950,756$ -$ 4,573,925$ 9,430,006
47
48
49 PRIOR YR INC July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June YTD INC TTD INC YTD UNUSED INC TTD UNUSED INC FCST BAL.
50INCOME TO DATE $ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 1,333,039$ 1,333,039
51INCOME COMMIT$ -$ -$ 1,333,039$ 1,333,039
R&T Template



Here's the workbook of the report I would need to validate against:

Book to Compare.xlsx
ABCDEFGHIJK
1
2
3
4
5
6 Report-Id : ABC123 SOME COMPANYPage : 1651
7 396510 Project /Dept As of FEB / 2025 Run Date : 03/05/2025
8 -------------------------------------------------- BUDGET PERFORMANCE REPORT Run Time : 11:08:19.000000 AM
9 Department / Management Center
10 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------
11 TOTAL ADMIN. INSTRUCT.& COST SHARE SUBTOTAL RESEARCH & GIFTS & ENDOWMENT SUBTOTAL
12 DEPT.SUPP. UNFUNDED TRAINING GRANTS & FHBO FUNDED
13 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------
14511000 BUDGET Original
151 Control Revised
16----------------------------------------------------------------------------------------------------------------------------------
17EXPENSES For Month23,1644,6724,67218,49218,492
18Year To Date106,59918,20718,20788,39288,392
19----------------------------------------------------------------------------------------------------------------------------------
20Balance-106,599-18,207-18,207-88,392-88,392
21--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
22513000 BUDGET Original
232 Control Revised
24----------------------------------------------------------------------------------------------------------------------------------
25EXPENSES For Month10,33210,33210,332
26Year To Date107,618107,618107,618
27----------------------------------------------------------------------------------------------------------------------------------
28Balance-107,618-107,618-107,618
29--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
30514000 BUDGET Original
313 Control Revised
32----------------------------------------------------------------------------------------------------------------------------------
33EXPENSES For Month131131131
34Year To Date131131131
35----------------------------------------------------------------------------------------------------------------------------------
36Balance-131-131-131
37--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
38515000 BUDGET Original45,00045,00045,000
394 Control Revised45,00045,00045,000
40----------------------------------------------------------------------------------------------------------------------------------
41EXPENSES For Month25,7293,3463,34622,38322,383
42Year To Date203,50530,25830,258173,247173,247
43----------------------------------------------------------------------------------------------------------------------------------
44Balance-158,50514,74214,742-173,247-173,247
45--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
46516000 BUDGET Original43,42143,42143,421
475 Control Revised43,42143,42143,421
48----------------------------------------------------------------------------------------------------------------------------------
49EXPENSES For Month23,0474,7004,70018,34818,348
50Year To Date174,31812,10312,103162,215162,215
51----------------------------------------------------------------------------------------------------------------------------------
52Balance-130,897-12,103-12,103-118,794-118,794
53--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
54517000 BUDGET Original
55Technical & Trade Control Revised
56----------------------------------------------------------------------------------------------------------------------------------
57EXPENSES For Month940940940
58Year To Date940940940
59----------------------------------------------------------------------------------------------------------------------------------
60Balance-940-940-940
61--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
6251Z000 BUDGET Original27,45815,30015,30012,15812,158
63Fringe Benefit Control Revised27,45815,30015,30012,15812,158
64----------------------------------------------------------------------------------------------------------------------------------
65EXPENSES For Month22,2072,7361,3084,04418,16418,164
66Year To Date145,19314,4035,09819,501125,692125,692
67----------------------------------------------------------------------------------------------------------------------------------
68Balance-117,735897-5,098-4,201-113,534-113,534
69--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
70BUDGET Original115,87960,30060,30055,57955,579
71Revised115,87960,30060,30055,57955,579
72----------------------------------------------------------------------------------------------------------------------------------
73EXPENSES For Month105,55110,7815,98016,76188,79088,790
74Year To Date738,30556,76423,30580,069658,235658,235
75----------------------------------------------------------------------------------------------------------------------------------
76* Total For Salaries * Balance-622,4263,536-23,305-19,769-602,657-602,657
77--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
78531000 BUDGET Original
79General Supplies Control Revised
80----------------------------------------------------------------------------------------------------------------------------------
81EXPENSES For Month56,4512,0244,8516,87549,57649,576
82Year To Date337,42617,8584,85122,709314,718314,718
83----------------------------------------------------------------------------------------------------------------------------------
84Balance-337,426-17,858-4,851-22,709-314,718-314,718
85--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
86532000 BUDGET Original
87Internal Services Control Revised
88----------------------------------------------------------------------------------------------------------------------------------
89EXPENSES For Month
90Year To Date695340340355355
91----------------------------------------------------------------------------------------------------------------------------------
92Balance-695-340-340-355-355
93--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
94533000 BUDGET Original
95Outside Services Control Revised
96----------------------------------------------------------------------------------------------------------------------------------
97EXPENSES For Month264,253264,253264,253
98Year To Date2,881,5817607602,880,8212,880,821
99----------------------------------------------------------------------------------------------------------------------------------
100Balance-2,881,581-760-760-2,880,821-2,880,821
101--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
102534000 BUDGET Original
103Travel & Related Expenses Cont Revised
104----------------------------------------------------------------------------------------------------------------------------------
105EXPENSES For Month
106Year To Date9,1011621002628,8398,839
107----------------------------------------------------------------------------------------------------------------------------------
108Balance-9,101-162-100-262-8,839-8,839
109--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
110535000 BUDGET Original
111Communications & Shipping Ctl Revised
112----------------------------------------------------------------------------------------------------------------------------------
113EXPENSES For Month3723563561717
114Year To Date1,3251,0721,072253253
115----------------------------------------------------------------------------------------------------------------------------------
116Balance-1,325-1,072-1,072-253-253
117--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
118536000 BUDGET Original
119Equipment Control Revised
120----------------------------------------------------------------------------------------------------------------------------------
121EXPENSES For Month7,6297,6297,629
122Year To Date375,668375,668375,668
123----------------------------------------------------------------------------------------------------------------------------------
124Balance-375,668-375,668-375,668
125--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
126539000 BUDGET Original
127Expense Error Control Revised
128----------------------------------------------------------------------------------------------------------------------------------
129EXPENSES For Month
130Year To Date147147147
131----------------------------------------------------------------------------------------------------------------------------------
132Balance-147-147-147
133--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
134541000 BUDGET Original
135Maint Materials & Supplies Revised
136----------------------------------------------------------------------------------------------------------------------------------
137EXPENSES For Month
138Year To Date262262262
139----------------------------------------------------------------------------------------------------------------------------------
140Balance-262-262-262
141--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
142543000 BUDGET Original
143Maintenance & Repairs Control Revised
144----------------------------------------------------------------------------------------------------------------------------------
145EXPENSES For Month
146Year To Date1,3131,3131,313
147----------------------------------------------------------------------------------------------------------------------------------
148Balance-1,313-1,313-1,313
149--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
150551000 BUDGET Original
151Insurance Control Revised
152----------------------------------------------------------------------------------------------------------------------------------
153EXPENSES For Month1,9111,9111,911
154Year To Date9,4149,4149,414
155----------------------------------------------------------------------------------------------------------------------------------
156Balance-9,414-9,414-9,414
157--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
158556000 BUDGET Original7,750,0007,750,0007,750,000
159General Miscellaneous Control Revised7,750,0007,750,0007,750,000
160----------------------------------------------------------------------------------------------------------------------------------
161EXPENSES For Month
162Year To Date
163----------------------------------------------------------------------------------------------------------------------------------
164Balance7,750,0007,750,0007,750,000
165--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
166BUDGET Original7,750,0007,750,0007,750,000
167Revised7,750,0007,750,0007,750,000
168----------------------------------------------------------------------------------------------------------------------------------
169EXPENSES For Month330,6162,3804,8517,231323,386323,386
170Year To Date3,616,93120,1914,95125,1423,591,7893,591,789
171----------------------------------------------------------------------------------------------------------------------------------
172* Total For Non-Salaries * Balance4,133,069-20,191-4,951-25,1424,158,2114,158,211
173--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
174BUDGET Original7,865,87960,30060,3007,805,5797,805,579
175Revised7,865,87960,30060,3007,805,5797,805,579
176----------------------------------------------------------------------------------------------------------------------------------
177EXPENSES For Month436,16713,16110,83123,991412,176412,176
178Year To Date4,355,23676,95528,256105,2124,250,0244,250,024
179----------------------------------------------------------------------------------------------------------------------------------
180* Total For Salaries & Non-Salaries * Balanc3,510,643-16,655-28,256-44,9123,555,5553,555,555
181--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
182538000 BUDGET Original1,751,0001,751,0001,751,000
183Indirect Cost Recovery Control Revised1,751,0001,751,0001,751,000
184----------------------------------------------------------------------------------------------------------------------------------
185EXPENSES For Month108,1313,6483,648104,483104,483
186Year To Date715,00914,27714,277700,732700,732
187----------------------------------------------------------------------------------------------------------------------------------
188Balance1,035,991-14,277-14,2771,050,2691,050,269
189--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
190BUDGET Original9,616,87960,30060,3009,556,5799,556,579
191Revised9,616,87960,30060,3009,556,5799,556,579
192----------------------------------------------------------------------------------------------------------------------------------
193EXPENSES For Month544,29813,16114,47827,639516,659516,659
194Year To Date5,070,24476,95542,533119,4894,950,7564,950,756
195----------------------------------------------------------------------------------------------------------------------------------
196* Grand Total * Balance4,546,634-16,655-42,533-59,1894,605,8234,605,823
197--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
396510



I've highlighted the validation cells in blue. You can see the that the 3 digit value in the first work (U6) book coordinates with the first 3 digits in the 6-digit number in the second workbook (A14). The values to validate are always 4 rows down and 7 columns over. There are few sticky items as well:

1. The values in the first workbook have two decimal places. the values in the second workbook don't.
2. The second workbook has the ever damning multiple data in a cell that comes standard with legacy systems.
3. The second workbook's file name will change every month.
4. There are 3 values that need validation that aren't associated with a 3-digit code (yellow highlight). Not sure how to attack these and maybe it's just better to eyeball these.

Just looking for a bit of direction and willing to take it further on my end with a sufficient nudge/start. I can likely apply this to multiple, similar exercises so this would be a generous timesaver.


This community is always helpful and instructive. Thanks for the review and consideration.


jski
 
Sort by date Sort by votes
I understand your struggle, Let's automate a summary sheet like one below and If there are no discrepancies in values, we can take it to the next level. Plus, even the summary will make your work easier. I guess so, What do you think?
VBA Find Characters in String, Locate Value in Another Column, Validate Value in Another Worksheet.xlsm
ABCDE
1Budget+CodeExpense_ClassYear_to_Date ValueValue_R&T TemplateValidate
2511000 BUDGET Original5118839288391.57OK
3513000 BUDGET Original513107618107618.39OK
4514000 BUDGET Original514131131.25OK
5515000 BUDGET Original515173247173247.08OK
6516000 BUDGET Original516162215162215.33OK
7517000 BUDGET Original517940940.06OK
851Z000 BUDGET Original51Z125692125691.72OK
9BUDGET Original658235658235.4OK
10531000 BUDGET Original531314718314717.8OK
11532000 BUDGET Original532355354.76OK
12533000 BUDGET Original53328808212880821.25OK
13534000 BUDGET Original53488398838.96OK
14535000 BUDGET Original535253253.23OK
15536000 BUDGET Original536375668375667.61OK
16539000 BUDGET Original539147147OK
17541000 BUDGET Original541262261.69OK
18543000 BUDGET Original54313131312.74OK
19551000 BUDGET Original55194149413.85OK
20556000 BUDGET Original5560OK
21BUDGET Original35917893591788.89OK
22BUDGET Original42500244250024.29OK
23538000 BUDGET Original538700732700731.5OK
24BUDGET Original49507564950755.79OK
Summary
 
Upvote 0
I don't understand below.
jski21 said:
4. There are 3 values that need validation that aren't associated with a 3-digit code (yellow highlight). Not sure how to attack these and maybe it's just better to eyeball these.
Click to expand...
Code: 
Sub test()
    Dim fn$, wsName$, temp, x, f$, ws As Worksheet
    fn = Application.GetOpenFilename("ExcelFiles,*.xls*")
    If fn = "False" Then Exit Sub
    Set ws = Sheets("r&t template")
    wsName = GetSheetName(fn)
    f = "'" & Left$(fn, InStrRev(fn, "\")) & "[" & Mid$(fn, InStrRev(fn, "\") + 1) & "]" & wsName & "'!"
    temp = ws.[a1]: ws.[a1].FormulaArray = "=max(if(" & f & "a:a<>"""",row(a:a)))"
    x = ws.[a1]: ws.[a1] = temp
    With ws.Range("u6", ws.Range("u" & Rows.Count).End(xlUp)).Offset(, 1)
        .Formula = "=if(len(u6)=3,if(round(n(q6),0)=iferror(index(" & f & "g$10:g$" & x + 6 & _
            ",match(u6&""*""," & f & "a$6:a$" & x & ",0)),""^""),""OK"",""NF""),"""")"
        .Value = .Value
    End With
End Sub

Function GetSheetName(fn As String) As String
    With CreateObject("DAO.DBEngine.120").workspaces(0).OpenDatabase(fn, True, True, "excel 12.0;HDR=No;")
        GetSheetName = Replace(.tabledefs(0).Name, "'", "")
        GetSheetName = Left$(GetSheetName, Len(GetSheetName) - 1)
        .Close
    End With
End Function
 
Upvote 0
Solution
Fuji--amazing and that worked like a charm! Thank you. I'm walking through this to drink in the logic but there is a fair amount here I'm unfamiliar with. A brief run through if you have the time? With regard to your question on item #4, if you look at the second spreadsheet above (Book to Compare.xlsx) there are three values highlighted in Column G beginning at Row 170 that aren't associated with a 3-digit number (they are totals). Again, unlikely these can be folded into the code without that type of designation and it may be just easier to eyeball these 3 as opposed to doing it for 33.
 
Upvote 0
I see yellow cells in col.G on row 170, 178 and 194.
Looks like it associated with "BUDGET Original" in col.A and there are more cell(s) other than above 3 cells.

What is the condition to find those 3 and what do you want to do with them?
 
Upvote 0
These are YTD totals form the Book to Compare.xlsx file so no hard conditions per se. The report may change form month-to-month but from a condition standpoint you could assume:


Row 170 - This will always appear in Column G after the first instance of 'Year To Date' after the first instance of 'BUDGET Original' in Column A.

Row 178 - This will always appear in Column G after the second instance of 'Year To Date' after the second instance of 'BUDGET Original' in Column A.

Row 194 - This will always appear in Column G, 2 rows above '* Grand Total * Balance' at the very bottom of the report in column A.
 
Upvote 0
The first instance of "BUDGET Original" appears in A70 and "Year to date" after A70 is on A74.

How do you determine A170 as the first appearance of "BUDGET Original"?
 
Upvote 0
You must log in or register to reply here.

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top