Hi
Attached is the module that does your work...
Hope it suffices..
Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Fri, Jul 24, 2009 at 11:22 PM, Lee wrote:
>
> Here is the link to the file.
>
> www.progressivetel.com\~radney4\testdata
Hi
Can u please attach a sample sheet...
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Sat, Jul 25, 2009 at 1:22 AM, Telenochek wrote:
>
> Hello everyone,
>
> I have a worksheet that calculates system performance on Sheet1 b
I've got a list of URLs in excel that i need to delete everything
after the .com in the url. Could someone assist me with how to do this?
--~--~-~--~~~---~--~~
--
Some important links f
Good idea. Your suggestion gave me this idea:
Lock the entire column that contains the child count and when a value
is entered into the key column on a new row (the license number), use
a macro to insert the formula into the locked column.
I guess I was hoping there was a way to assign a formula
Hello everyone,
I have a worksheet that calculates system performance on Sheet1 based
on electronic components, whose data is located in other Sheets
(sheets 2,3...n).
I would like to have the user simply select a component from another
sheet to place in a system, and have it import the rest of
Here is the link to the file.
www.progressivetel.com\~radney4\testdata.xls
Thanks!
Lee
On Jul 24, 12:40 pm, vivek agrawal wrote:
> Hi
>
> i would suggest you send the file so that the workaround can be figured
> out...
>
> Thanks and Regards,
> Vivek Agrawal
> Skype ID - vivek.agrawal83
>
> Go
first of all,
record a macro in which you open one of the files in the folder
the way you want to open it (space delimited, skip columns).
Next, check out the documentation on the "Files Collection",
the example looks like:
Sub ShowFolderList(folderspec)
Dim fs, f, f1, fc, s
Set fs = Cre
I think a fairly 'simple' way to do it is using a worksheet_change event.
When the sheet is changed, have the event check to see if the column
changed is a specific column that always has data.
then, the macro could unprotect the sheet, insert the formula, then
re-protect the sheet.
sound feasible
How are you wanting to "see" the earliest of the two records?
How are you searching?
How much control over the file do you have?
If you sorted the file by uniqueId, Date, then time,
you could use vlookup to look up the uniqueId and return
the date, then a second vlookup to return the time.
vlooku
I would like to apologize if this has been answered in another thread,
but I could not find it in the searches I was doing. Maybe I was
searching the wrong thing...
I am a software developer trying to create a temporary solution to a
problem using Excel 2007. One of our divisions needs to track a
Hi
i would suggest you send the file so that the workaround can be figured
out...
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Fri, Jul 24, 2009 at 6:58 PM, Lee wrote:
>
> I have a bunch of test data. Column A is the date,
Hi Anil
The segregation of the full name into first and second name is based on self
judgement in case of 3 word names... how would you like to separate into
two names
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Fri, Jul
Hi everyone...
First off, i am not a VBA guru, so most of the stuff I have found is
from the net...
I have a folder with 10 .txt files (maybe more eventually) that need
to be imported into a single excel document. I have the following code
i found, to import one, but it is not space delimiting, o
i have 2 identical excel files updated by 2 different people. How do I
synchronise the data into 1 file?
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA
I have a bunch of test data. Column A is the date, Column C is the
time and Column E is the unique identifier. Because this is test
data, a failed unit might be tested multiple times. What I need is a
way to find the earliest test time of the unique identifier in Column
E.
How do I restrict th
Hi Gyanesh,
The attached file contained the answer which is desired by you.
Thanks & Regards,
Dhananjay
(Mob. No. 9922255533)
On 7/21/09, gyanesh jain wrote:
>
>
> Hi All,
>
> check the attachment.
>
>
> If you change the country, in the chart "chart Title" should be change
> automatically.
Hi Aamir,
Can you give me the example sheet?
Thanks & Regards,
Dhananjay
(Mob. No. 9922255533)
On 7/21/09, Aamir Shahzad wrote:
>
> Dear all,
>
> Can anyone tell me please "How to make unique key" for pick required data
> from one sheet to another. If there is no similarity. e.g. for use of
Hi All Frnd & Sr.
Please find attached file. there is a Full Name Like Anil Kumar Panchal I
want saprate anil kumar panchal in 3 Columns with the help of formula like
find ya other
Thanks in advance
Anil Kumar
--~--~-~--~~~---~--~~
---
Hi.
In the VBE window, click on the Tools / References menu and select
"Microsoft Outlook nn Object Library" where "nn" depends of your version of
Office.
Alternatively, you can write :
Dim olApp As Object
Regards.
Daniel
> -Original Message-
> From: excel-macros@googlegroups.com [mail
Hi Rehan
follow the following steps.,.
1. apply auto filter to the table
2. open the drop down of column "Revenue"
3. move mouse over "number filters"
4. in the menu the opens alongside -> select "between" - the last entry in
the second section
5. a new menu pops up... enter the upper and the low
Hi Debashis
go to this link
http://groups.google.com/group/excel-macros/files?&sort=date
right click on the first file and save it directly... it gets saved... i've
checked it just now..
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save
21 matches
Mail list logo
