sandy armstrong
Last Activity: Feb 21 '12, 04:16 PM
Joined: Oct 6 '11
Location:
-
Guido that table finder is soo cool i love how it works. for table3 it would soo neat if it would bring you the email address also. but i know the email is hidden by a types of fire walls. I love this new tools thanks for your help after all this time. -
Thanks Guido. I attached the wrong work bok my mistake. I have attached the correct one now what is going on is that the marco that goes into the URL in column K and export the data is working but there is no data being place where it needs to go. that is what leads me to be leave that the website change the source code. PLease let me know what you think. Any help is apperciate....Leave a comment:
-
OK no problem I have attached the folder Thanks for your help....Leave a comment:
-
Hey Guido,
It been A long time..
I dont know what happened with this code that you helped me delvop. I think the website changed there source code because the marco works but no data is beening imported. I tryed in all the examples that we have copied to this forum and it not working Please Guido call you help me tell what is wrong...
Thanks for you helpLeave a comment:
-
cut row based on date in column
Hello,
I have a small problem and i would appericate help if anyone could...
I have a fairly large database in excel2010 that in being updated everyday by a employee. In column A there are a set of dates all in the same format 9/1/2011 what i would like to happen is that if there are any dates in column A then it cut out the row and paste it into Sheet1(the data is stored in sheet2) Please any help would be great!!! -
Now i just use MS Excel and Word but there can be several 100s of different worksheets that i will mail merge from. and with different users inputing data in there also, and i dont want anyone to put someones name again after they have ask to be removed from the our list.Leave a comment:
-
Block List in Outlook
Hello everyone, I would like to know if there is a way to create a block list so that when I do a mail merge using word and outlook I will not email People that have asked to be removed. My email list are being updated by other users in my company so I don’t want them to make a mistake when collecting data and put someone on the list that has already asked to be removed. Please any guidance in this would be very helpful. -
Hey Guido Just a thought... Can these to code be combined in order to perform this action together. right now what i do is run one macro then call up the other when that one finishes... I was just thinking it would make it easier. Right now as we speak i am running the first marco on 11,000 and if works great the after that it runs the second part. it takes a whole 24 hours to complete the task fully. ThanksLeave a comment:
-
Ohh okay thanks. I guess i was doing it the really long and dum way thanks guido...Leave a comment:
-
Wow Guido thanks for this it looks like so much I’m a little intimidated to use this. How do I transfer the tool into the worksheet that I going to use this in. what I do is that is just copy and paste everything into the correct workbook, I just would like to know if there is an easier way to do it.
Thanks for your help...Leave a comment:
-
outlook block list
Hello everyone, I would like to know if there is a way to create a block list so that when I do a mail merge using word and outlook I will not email People that have asked to be removed. My email list are being updated by other users in my company so I don’t want them to make a mistake when collecting data and put someone on the list that has already asked to be removed. Please any guidance in this would be very helpful. -
OK thanks guido thanks for the fast respone....
I like the idea of puting in a range column k to the last row because i really only use the columns.
Again thank you!!!!@Leave a comment:
-
Hello Guido, I would soo apperciate the help with this i have spent days trying to find out what is the problem. one speadsheet is not merging into the combine worksheet for some reason and i dont know why. so far i have 2 practicelink and file 1. File 1 is not merging into Merge_v3...Leave a comment:
-
Hey Guido,
I got it to work on my real file but for some reason it dosent grab all of them??? i dont know whyLeave a comment:
-
Thank Guido,
Thanks for the help on this Macro, This is what i was looking for but I would like to cut the Entire Row and paste it into sheet 2.
...Code:Option Explicit Sub MoveYesToCompleted() Dim ShPendingNextRow As Long Dim ShPendingLastRow As Long Dim ShCompletedBlankRow As Long ShPendingLastRow = Worksheets("Pending").Cells(Rows.Count, "A").End(xlUp).RowLeave a comment:
-
excel...Copy row based on word in cell
Hello and goodMorning,
Can anyone please help me with this. I have a database in excel that has 2 sheets full of data. I would like if i press a button to update then macro searches in Column O if the words " Req. Feed Set Up" then it get move over to sheet 2 in the workbook.
Sub Feed_set_up()
Dim intLastRow As Long
intLastRow = ActiveSheet.Use dRange.Rows.Cou nt
'Let's start... -
I dont know What is wrong with it only does the first row and thats it. Thanks Guido I am going to work on today and try to firgure it out i will give you any update once i got it thanks Once again :-)Leave a comment:
-
copy row based on critiera
Hello and goodMorning,
Can anyone please help me with this. I have a database in excel that has 2 sheets full of data. I would like if i press a button to update then macro searches in Column O if the words " Req. Feed Set Up" then it get move over to sheet 2 in the workbook.
Sub Feed_set_up()
Dim intLastRow As Long
intLastRow = ActiveSheet.Use dRange.Rows.Cou nt
'Let's... -
excel and outlook
would like to know if this is even poosible???
I have a simple speadsheet that has some simple headers Email/ TypeMess. / Email link /Date
And maybe Name of contact if it can be added
Everytime a email is either sent or recived from my outlook it stamps email address in coloumn A if it was sent or recived in column B Either a link to the email or the either the body of the email in cloumn C and the date... -
Hello, GUido thanks for this tool I was trying to use the user form that is used to add the PPO# but i keep getting an error on
ARRDUMP = Range("G2").Res ize(ROWlastREC, 2)- this line
But this is sooo cool Im in love with this! thanks soo muchLeave a comment:
No activity results to display
Leave a comment: