*Dear VBA Experts,*
I'm wondering if there is a code possible to summarize the contents of a
text file as partly shown below.
I received this file at a certain period. Thousands rows of records. Each
data contains code and date time stamps. The first line is logged in and
the next logged out, the
Great Kudos and blessing to Ayush Jain. You will have a great legacy for
helping others and sharing your candlelight. Indeed, sharing your light
with others do not diminish its brightness but multiply it.
On Fri, Apr 2, 2010 at 11:26 PM, ayush jain wrote:
> Dear Members,
>
> Thanks for all you
>
>
>
> Hope It Will Help
> Happy To Help
> :)
> Shyam
>
>
> On Fri, Mar 19, 2010 at 12:52 PM, OSAVentures Calamba
> wrote:
> > Hi All, I'm trying to fill C6 with value of 1 then selecting that and
> > filling the cell bel
Hi All, I'm trying to fill C6 with value of 1 then selecting that and
filling the cell below it with series until the last row of B, my code is
not working. whats wrong? thanks
Sub Fillnumber()
ActiveSheet.Unprotect
curr_row = Range("C6").Row
curr_col = Range("C6").Column
last_row
dear all,
i have a dynamic column A which i used as a lookup value formula in column
B, but since the column A is dynamic, how to create a vba code to copy the
formula in say B1, down to the last row equal to column A.
im using excel2003 . thanks a lot.
--
--
dear expert,
im new in vba but my work is truly repetitive. I want to select a range and
print preview it.
example my row heading is row 1:5, and my column heading is col A:D, I want
to select the range starting row 6 until last column with data and last row.
Any VBA please. Microsoft helps pro
*Dear VBA experts,*
I have a database( excel 2003 spreadsheet) with various columns. I have
dynamically named each column for me to execute a a sum, lookup, or count
later with less confusion.
I want to create a code to insert a temporary "report sheet" to populate say
column A with unique recor
Thanks to all the great suggestions. There are really a lot of ways to do
things in excel.
On Mon, Mar 15, 2010 at 4:02 PM, OSAVentures Calamba wrote:
> dear helpful experts,
>
> how to find the corresponding value in a column matching 2 criterias.
>
> please help with this loo
dear helpful experts,
how to find the corresponding value in a column matching 2 criterias.
please help with this look up formula to find the value as per attached
worksheet. many many thanks to all.
thanks
davegla
--
--
great answer
On Tue, Mar 9, 2010 at 12:02 AM, Paul Schreiner wrote:
> If I follow your question correctly, you're asking: "why would I need
> vba?"
>
> the answer is directly related to time, and repetition.
>
> At our location, we had an employee that spent 2 MONTHS gathering and
> organizing d
Thanks to all the great suggestions provided.
On Fri, Feb 26, 2010 at 7:36 PM, Dave Bonallack
wrote:
> Hi OSAVentures,
>
> Have a look at the attached to see if you can adapt it to your own needs.
>
> Regards - Dave.*
> *
> --
> Date: Fri, 26 Feb 2010 14:53:14 +0800
>
How to select unique values from a list and copy each to another location
of another worksheet? Not using auto-filter or advance filter?
Thanks.
--
--
Some important links for excel users:
1. Follow us on TWITTER f
here is simple the solution. Ernie from Calamba, Philippines.
On Mon, Feb 22, 2010 at 11:24 AM, Akash $urkatha wrote:
> Dear Rohan,
>
> I have tried that formula. Its fine for normal calculations. But its not
> showing correct result when my activity starts on say Monday afternoon 12:00
> Hrs a
sorry the correct column should be = e3-c3+ ( d3-b3). my aplogy.
On Mon, Feb 22, 2010 at 1:51 PM, OSAVentures Calamba wrote:
> First please removed the date stamp with your time ( "1/1/1900") default
> time stamped on your column e. if you have those in column b, remove them
&g
First please removed the date stamp with your time ( "1/1/1900") default
time stamped on your column e. if you have those in column b, remove them
as well
Then just use simple formula of =c3-d3 + (d3-b3). it should give you
correct number of hours.
ernie
On Mon, Feb 22, 2010 at 1:31 PM, Dav
*Dear Gurus,*
I'm trying to clean up my vba code for printing a named ranged. My problem
is i want to ask the user to input a data to meet a criteria, and then if
that while that criteria is true, it prints a certain range.
Here's my code, IT DOESNT SEEM TO PRINT THE RANGE SPECIFIED BY THE USER
close the workbook, this can help
>
> write
>
> If not isblank(target) then:thisworkbook.close(false)
>
> inside worksheet_change() event
>
>
> With regards
>
> Hemant Hegde
>
>
> On 10/11/2009, OSAVentures Calamba wrote:
>>
>> Dear Paul and gurus,
>>
>>
ge to 10?
>
> do you want to save the workbook when it closes?
>
> You could create an event:
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> test for whatever you're testing for:
> If (Target.Row = 10) then
>
> then:
>
>
> ThisWorkbook.Close
dear gurus,
say i have a worksheet, but i want to limit the printing of this worksheet
to 10 times only. is it possible?
any vba idea. most probably this is a worksheet print event?
im new to macro. thanks for understanding.
dellosa
--~--~-~--~~~---~--~~
-
; do you want to save the workbook when it closes?
>
> You could create an event:
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> test for whatever you're testing for:
> If (Target.Row = 10) then
>
> then:
>
>
> ThisWorkbook.Close savechanges:=False
&
; Please, give us more information about your problem...
>
> Best Regards
>
> On 9 nov, 02:31, OSAVentures Calamba wrote:
> > dear gurus,
> >
> > i need to close a workbook if last row with data
dear gurus,
i need to close a workbook if last row with data =10, Any VBA suggestion
please?
dellosa
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tu
Dear Dave and Dilip,
The solution you suggested where out of the box. Its genuis, While I solved
it by naming uniquely each rows, and implement "ifs" to lookup on it based
on criteria. Although returning the correct values, I discarded my long
formula and adapted your great ideas.
Its simply magi
Dear Gurus,
Im trying to look up a value from a table and return a cell reference in a
that worksheet based on the value returned.
quite tricky and i need your help.
I attached a file to explain.
Dellosa
--~--~-~--~~~---~--~~
--
e, _
>' Transpose:=False
>' Application.CutCopyMode = False
>
> 'Again declaring and setting the sourceRange adn
> targetCell this way
>'simplifies the code.
> 'Notice
Hello Excel Gurus, Im not sure why this macro works and sometimes not.
Could you please comment.
Sub Find_First_before_ Copy_Paste()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With
Dim FindString As Integer
Dim Rng As Range
FindString = Shee
;Computation").Select
> > ActiveCell.Offset(1, 0).Select
> > Selection.Copy
> > Sheets("PAYSLIP").Select
> > Range("D41").Select
> > Selection.PasteSpecial Paste:=xlPasteValues
> > Application.CutC
Dear Macro Experts,
I'm just starting to write a macro. What I'm trying to do is I want to copy
a value from 'computation' sheet.column B and posting it as values in 'Slip'
range "D4" and do that while sheet.columnB is not empty. Below is the code
i made but stops.
Sub copyIDtopay()
With Ap
good day excel gurus,
im always printing a template worksheet with values. I'm wondering how to
automate this process.
the template needs to print *N* number of times, *N*=number of rows with
data in another sheet. Also options to select row with data to print in
the template.
However, in the
Good day All,
I'm writing to request your idea. Here is my problem.
I have a template workbook with many multiple sheets. In one sheet(1) I
have values in a column A. say row1 = 1, row2=2.. and so on...
I want to print a certain range in another sheet(2) up to the last value in
column a of she
cracking password of other programmers without his knowledge is a bad habit
much less a moral crime and a disrespect to the author. I hope this forum do
not tolerate this practice. let us help each other in the right way as we
always do. thanks for understanding.
On Mon, Oct 19, 2009 at 1:37 AM,
dear excel genuises,
may i request your help how to change the default message in excel 2003
status bar? and prevent the user from changing it.
thanks a lot. may god shower you with graces.
dellosa
--~--~-~--~~~---~--~~
---
There are many lookups, what kind of information you need to warrant the
lookup function. Please tell us what is your problem precisely. dont make
us guess.
On Sat, Oct 3, 2009 at 12:20 PM, Equity Monk wrote:
> Dear Friends,
>
> I am attaching a portfolio. It is a mf portfolio.
> If you can pls
33 matches
Mail list logo
