Seems to me (as I have already commented on another site with pretty much the same post from the OP) that OP will be sending out spam to private cell phone numbers.
As far as Im concerned, I just feel that people (myself included) get enough unwanted and unasked for spam and other advertising crap on their phones, that it just would not sit right to assist in it's proliferation
Re: Excel not linking external files
Not really sure what the problem might be, I constructed this with no problems, both with the source open, and closed...
=VLOOKUP(B1,'H:\\path1\[name-or-file-that-I-used.xlsm]Formulas 1'!$A$1:$C$22,2,0)
Re: Conditional Formating Turns Cell Red if <30 - Can I get alerts on one worksheet?
No need to use "reply with quotes" unless there is a specific comment you need to refer to 
Why just reference the cells you need to test, from the Main sheet, and if they exceed the criteria, display a warning. Something like...
=if(sheet1!A1>=TODAY()+20,"Check","")
Re: Drag Down Formula, but only change worksheet number
If the source WB will also be open, you could use INDIRECT
=indirect("'[CCS Client Case Eligibility Review Tool (Qtr2).xlsm]Weslaco ("&rows(1:1)&")'!$G$8")
If the source will not be open, consider installing the Moreunc add-in which permits using INDIRECT on closed WB's
[TABLE="width: 64"]
http://www.ashishmathur.com/tag/morefunc/
[/td]
[/TABLE]
Re: Increment number within variable length alphanumeric string
This turned into a beast because of the variable nature of your dats...
[Table="width:, class:grid"]
A
B
C
D
1
T247-e
T248-e
T249-e
T250-e
2
Transect6
Transect7
Transect8
Transect9
3
17
18
19
20
4
Tran24w_b
Tran25w_b
Tran26w_b
Tran27w_b
5
19(b)
20(b)
21(b)
22(b)
6
Transect 6221
Transect 6222
Transect 6223
Transect 6224
[/table]
Quoteb1=LEFT(A1,FIND(LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$10000)))),A1)-1)&LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$10000))))+1&MID(A1,FIND(LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$10000)))),A1)+LEN(LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$10000))))),99)
copied down and across
However, this can be shortened considerably if you are willing to use a helper column to ID the number (you can hide this if needed)...
[Table="width:, class:grid"]
A
B
C
10
T247-e
247
T248-e
11
Transect6
6
Transect7
12
17
17
18
13
Tran24w_b
24
Tran25w_b
14
19(b)
19
20(b)
15
Transect 6221
6221
Transect 6222
[/table]
B10=LOOKUP(99^99,--("0"&MID(A10,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A10&"0123456789")),ROW($1:$10000))))
C10=LEFT($A10,FIND($B10,$A10)-1)&$B10+COLUMN(A1)&MID($A10,FIND($B10,$A10)+LEN($B10),99)
both copied down AND ACROSS as needed
Re: Using a value from a cell inside a formula
There are quite a few exce3l functions that either work a little differently - or not at all - in google sheets
Re: Linking sequential spreadsheets and accessing updated data in the final spreadshe
Rcollie it is never a good idea to include personal info in a public forum like this.
I strongly suggest that you remove your phone number and email addy
Re: show only B6 drop down menu Invoice no. only
Im not really sure what you are asking here, could you provide some sample answers in your file?
To get Inv No in B7, I *think* you want this...
=INDEX('Purchase Accounts'!$D:$D,MATCH(Payments!$B$6,'Purchase Accounts'!$E:$E,0))
Re: Trim cell contents from both left and right
Another option, in case your data is not xxx-xxxx-xxxx...
=TRIM(RIGHT(SUBSTITUTE(LEFT(A2,LEN(A2)-5),"-",REPT(" ",125)),125))
with your data in A2
Re: SUM not working in certain cells only
QuoteR10 is pulling through £12,531 and R11 £112,137
If that is exactly what shows in the formula bar (not just the cell), then that is text, not a number - excel does not include currency symbols in the formula bar for real numbers.
If that is the case, then you need to track back and find out why the £ is being included in the cell
Re: #REF error when referring to external workbook
deleted - I really need to learn to read LOL
Re: Convert set of Data from Columns to Rows using VBA
sktneer some habits are hard to avoid lol, good to see you, too
Re: #REF error when referring to external workbook
What exactly is your formula?
INDEX/MATCH and VLOOKUP can both work on closed workbooks, so there must be something else in the formula...maybe INDIRECT?
Re: Formatting
QuoteI'm getting 01/01/1900 18:05:46
That probably means that the cell is Custom formatted as DATE/TIME. Try formatting just as TIME
Re: Convert set of Data from Columns to Row
Duplicate thread here?
http://www.ozgrid.com/forum/showthread.php?t=199510
Re: Convert set of Data from Columns to Rows using VBA
Duplicate thread here...
http://www.ozgrid.com/forum/showthread.php?t=199507
Re: Vlookup with Multiple Sheets
Perhaps a formula like this, copied down?
=IF(A2="","",VLOOKUP(A2,Sheet2!$A$1:$B$9,2,0))
adjust ranges as needed
Re: If statement
Sorry, I did not understand a word you just said there, plus your file really does not contain much info or data 
What you need to do, is...
- give some sample data
- provide some sample answers
- if necessary, explain how you got those answers.
Keep in mind, you know exactly what you have and what you want, while we have no clue
Re: Using Variables in a Userform
x-posted here...
http://www.mrexcel.com/forum/e…e-variables-userform.html
Re: Trying to create formula to exclude any cells that contain the word "D/C"
Try this...
[TABLE="class: grid"]
L
M
N
2
D/C aaa
2
3
bbb
4
D/C ccc
5
ddd
6
D/C eee
[/TABLE]
N2=COUNTIFS(L:L,"<>D/C*",L:L,"<>")
@ skywriter, it is not working because all the empty cells are also <> "DC*"
