Once again thanks all of you.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Pleas
Hi Mandeep,
You helped me over a year ago with this macro; however they changed the
formatting of the data and now are not using the word “Establishment” before
the company name and are also not using the word “Accounting Period Start Date
:” before the actual date and time; can you help to re
Great explanation: thanks
>
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Plea
In this case, DATAPAGE is a named range in your workbook.
You can try to find it by looking in the pull-down above the column headings:
or look in our Name Manager on the Formulas tab:
Either should show you where this ranged is defined.
Paul-
“Do all the g
=IF(($A3=0),"",(IF(VLOOKUP($A3,DATAPAGE,3)=),"",(VLOOKUP($A3,DATAPAGE,3)
It's the "DATAPAGE" I've never incountered. (there are no tabs that I see
with that name)
Anyone explain how it's used? The sheet it is in has started populating
wrong information.
--
Are you =EXP(E:RT) or =NOT(EXP(
