help++ 1８８８ 6785401 AT&Tsupport Number AT&TPHONE CALL CONTACT NUMBER
AT&TPHONE nUMBER AT&TCustomer service
help++ 1８８８ 6785401 AT&Tsupport Number AT&TPHONE CALL CONTACT NUMBER
AT&TPHONE nUMBER AT&TCustomer service
help++ 1８８８ 6785401 AT&Tsupport Number AT&TPHONE CALL CONTACT NUMBER
AT&TPHONE
row). The sheet is sorted on field 2. I normally do this
manually but the Excel they just sent me has over 1,000 rows and most of
the field 2s are non repeating.
Thank you,
Bob Engler
--
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
If columnA in sheet2 matches columnB in sheet1, append the data from the
row in sheet2 to the end of the row in sheet1. Sheet1 may have multiple
rows with the same column data and the data from sheet2 needs to be added
to all sheet1 matching rows. ie:
Sheet1:
hr abc ddd rrt
hr dew ggg wqq
hr
Hi,
I am using the following code to parse imported text to columns using a
comma as my delimiter. However is consistently skips a couple of rows each
time. On one row it rougly half way through the list it removes the comma
delimiter and on the very last row it does nothing at all. There a
At:=xlWhole)
> >> If Not rng Is Nothing Then
> >> Application.Goto rng
> >> Exit For
> >> End If
> >> End With
> >> Next wks
>
> >> End Sub
>
> &
e info??
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
> -Original Message-
> From: Bob
> Sent: Sunday, February 19, 2012 6:33 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Help with code please.
>
> I almost have the
I almost have the code the way I need it. BUT I want it to Find
everything within in the same Workbook, not just on the Index
Worksheet. Thanks in advance!!!
Private Sub CommandButton1_Click()
Dim IndividualSearch As String
IndividualSearch = InputBox("What's the part number you're looking
for?",
I'm trying to create an inventory tracking system to pinpoint a
specific
location(a simple one) which, when the part number is entered into the
Inputbox,
Excel will go to, select and highlight that cell where the part number
is
located. I'm familiar with VBA just don't know the code, also using
exc
gt; From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of Bob
> Sent: Jan/Sun/2012 03:24
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Concatinate
>
> I have a huge problem I just can not solve.I'm trying to concatinate severa
I have a huge problem I just can not solve.I'm trying to concatinate
several things. I have a user form with 15 optionbuttons. If specific
optionbutton are clicked then do a certain thing.. Such as If
optionbutton1 is clicked then put Always"350" Optionbutton1 is always
"S" then whatever is in Labe
How do I create an application in excel that hides all the components
of excel in order to have a stand alone custom applicaion. I posted
this earlier but without a subject I think. So Here is is again.
Thxn
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate t
Can someone help. I have a list in column C of email addresses. I'd
like to have a commandbutton once clicked to automatically attach all
the email names to an email to do a bulk email. Thanks in advance!!!
--
--
Some
On Sheet2 I have some rows that are highlighted in yellow and some
not. I'd like for when the user clicks on the command button to hide
all the rows NOT in Yellow. And another command button to unhide. I'm
familiar with installing the command buttons, just don't know how to
write the code to hide a
OMG!!! Thank you so much! Thats Perfect
On Aug 18, 10:56 pm, NOORAIN ANSARI wrote:
> Pls see attached sheet if it help to you
>
>
>
>
>
> On Fri, Aug 19, 2011 at 7:34 AM, Bob wrote:
> > I have a checkbox on Sheet1, When checked I want it to shade Grey or
>
I have a checkbox on Sheet1, When checked I want it to shade Grey or
Yellow A2:B2 on Sheet2. If not checked do not shade. Thanks so much
for any help!!
--
--
Some important links for excel users:
1. Follow us on TWITT
Please Help with code!
If CheckBox1 is Checked then Highlight Sheet2 Row 2 Column A & B
Thanks so much in advance!!!
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
htt
Is there a way to add a floating message box. Something that will stay
within view as you scroll down or up a page. Thanks in Advance!!
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tric
oops sorry, 291log
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871
=IF(A30="","",SUM(C3:C25)*ROUNDUP(Worksheet2!G3/G1,0))
I only need to Sum (C3:C25) ONCE, Then after that, Sum (C3:C10) for
the remaining.
Example: If G3 lets say is 100 and G1 is lets say 25 then Sum C3:C25
only ONCE then Sum C3:C10 for the remaining count which is 75 in this
example.
C3:C25
How do you write a macro to print Sheet1, A3:K only. Nothing from L
over. Thanks in advance!!!
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceld
Is there a way to print the rows with data in them and not print the
rows with just the formula. My spreadsheet has several rows with
formulas in them and I only want to print the rows which I have added
data. I know you can select print area and all that. But mainly it's
for the inexperianced user
This does work. But only for range B3. Is there a way to once B3 has
already been entered go to NEXT ROW. Thanks so much for your help!!!
On May 31, 1:45 am, Dilip Pandey wrote:
> Hi Bob,
>
> After your formula part of the code, insert the following:-
>
> If IsError(Range(&qu
I'd like to enter my own value if there is no match. As the code
stands now it will not allow
me to enter my own value, returns the #N/A error and each time I try
and change this it fires the code again and return the error again. I
need something like... If A3 = "#N/A" then Enter "Your Own Value"
Not sure if this will help but here a 2 different ways. Both will keep
date from changing the next day.
You can create a circular referance with this formula
=IF(B3="","",IF(C3="",NOW(),C3))
Or this will put the date in Column C using a macro
Private Sub Worksheet_Change(ByVal Target As Range)
If T
Try this...with a command button, Change your range as needed, this
one is A2:B1
Private Sub CommandButton2_Click()
ActiveWorkbook.Worksheets("Your Worksheet
Name").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Your Worksheet
Name").Sort.SortFields.Add Key _
:=Range("A2"), Sort
If there is no match, I'd like to enter my own value. Just can not
figure out how to write code! As the code stands now it will not allow
me to enter my own value, returns the #N/A error and each time I try
and change this it fires the code again and return the error again. I
need something like...
.
>
> with macro you can "automatically" keep the old data
> (and stored in another place)
> and then enter the new value in the same cell
>
> cmiiw
>
>
>
> On Mon, May 23, 2011 at 5:21 AM, Bob wrote:
> > Is there a way to keep the formula in the cell
Is there a way to keep the formula in the cell when you enter your own
value? Thanks in advance
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/excel
I'm having a problem with, when the code runs, once I type something
in cell A3 the formula is automatically copied down. Thats fine but it
copies down each time I selcet a cell. I do not want any blanks. I can
not just delete blank rows because there is something in columns F
thru M. One blank row
I need this formula within the VB code on "Over Flow Report", Column
"D". =IF(C3="","",B3*C3). I'm trying to understand how it works. Is
this correct? Do I need to add anything?, Should it go in the
worksheet_change or worksheet_select_change?
Worksheets("Over Flow Report").Range("D3").Formula =
"=
If I enter the Customer in B27 I'd like for todays date to be entered
in F27 automatically. How would you keep the date from changing the
next day, each time the workbook is opened? Thanks in advance!!!
--
--
Some imp
God bless you! That got it! Thanks so much!!!
On May 6, 1:53 am, Deepak Pal Singh wrote:
> Hi Bob,
>
> I'm sorry bro, I didn't understand your problem completely...
> There is a minor problem with the code that you"ve written.. If you copy the
> complete column t
Were is it located to attach file? Sorry I don't see it. Thanks
On May 6, 1:25 am, ashish koul wrote:
> can you share the sample file
>
>
>
>
>
> On Fri, May 6, 2011 at 5:22 AM, Bob wrote:
> > I'm sorry , Still having trouble with copy on next available bl
I'm sorry , Still having trouble with copy on next available blank
row. If I record a macro it's:
Columns("A:E").Select
Selection.Copy
Sheets("Customer Record").Select
ActiveSheet.Paste
I want to keep what I have already copied. How do I make it go to the
next available blank row.
Thank
Can someone help with the code to delete a workbook if password is not
entered within 3 tries. Thanks so much!
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://tw
For the life of me I can not figure out why this code will work fine
if more than 2 or more rows are Copied and Pasted. But if only one row
is copied and pasted It will not work. Any help at all, please! Thanks
in advance!
The code stops at ActiveSheet.Paste
Private Sub CommandButton2_Click()
'Co
wrote:
> Hi Bob
> Try
>
> Sub copydata()
> 'Copy contents from Sheet2 Columns A & B
> Sheets("Sheet2").Select
> Range("B1").End(xlDown).Select
> Temp1 = ActiveCell.Address
> Range("A1" & ":" & Temp1).Select
>
I'd like some help in Copying and Pasting in different worksheets.
Copy contents from Sheet2 Columns A & B
Paste contents on next available blank row on Sheet1 in Columns A & B
Thanks in advance!
--
--
Some important
I am OK with three different x and y values ... I'm not sure why that
never occurred to me!
Would it help to send you ALL of the data together?
On Nov 26, 9:22 am, Dilip Pandey wrote:
> Hi Bob,
>
> Ok, in order to determine the best Singular X and Y values we need to break
>
Y in a non-linear equation.
Thanks again for your help!
On Nov 24, 10:35 pm, Dilip Pandey wrote:
> Hi Bob,
>
> I have done something in the attached file.
> I believe if the x and y are not fixed at all the time, then we can
> use Goal Seek feature of Excel to obtain the desired res
ta ... but other
suggestions are also certainly welcome.
Hope you, or someone, can help! Thank you.
On Nov 23, 9:13 am, Dilip Pandey wrote:
> Hi Bob,
>
> This seems to be interesting to me. Would you mind providing some
> sample data with the the indicative result which you want to
Good afternoon,
I have a fairly large data set (roughly 7,000 samples) on which I
would like to run some nonlinear regression analysis.
I'm fully capable of using the Data Analysis Toolpak and running the
linear analysis there, but unless I'm totally missing it, there
doesn't seem to be a method
42 matches
Mail list logo
