AM UTC-4, JsinSk wrote:
>
> Hello Group,
>
> I'm attempting to automatically format a report that has several parts and
> break it down to what I need.
>
> The report comes in plain text and has three parts that all in with the
> phrase "total :" in the las
Hello Group,
I'm attempting to automatically format a report that has several parts and
break it down to what I need.
The report comes in plain text and has three parts that all in with the
phrase "total :" in the last part of that section. I'd like to see about
having it break down each secti
Can anyone else assist?
--
--
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
Hello, I would like to see about some assistance with the following
problem, due to some re-arranging in our warehouse I need to have a
report separate locations on different sheets.
Locations are listed as
AA-A-0
AA-A-1
AA-A-2
AA-A-3
AA-A-4
AA-B-0
AA-B-1
AA-B-2
AA-B-3
AA-B-4
AA-C-0 ... and so on
When you reply to a post the moderators must approve it before it will
appear. The delay in your reply and when it shows varies.
On May 25, 3:16 pm, hanumant shinde wrote:
> just checking if i can send a mail or not. i had sent a reply to 1 post but i
> cant see my reply. i dot know whats wrong.
I can guess how you want it formatted, but is it possible for you to
attach a sample excel sheet with the desired tabs/columns how you want
it?
On May 18, 3:31 pm, Susan 1 wrote:
> Hi ~
>
> Wondering if you could assist me with the Text import wizard to configure
> the columns and tab delimiter f
What format are your report files in?
On Apr 26, 11:46 am, "Chidurala, Shrinivas "
wrote:
> Please help.
>
> Regards,
> Shrinivas
> Citi(r) Global Transaction Services - India
> UB City, Canberra Block, # 24, Vittal Mallya Road,
> Bangalore - 56 00 01.
> Ph - +91-80-4144 6339 / 6340
> Email -
Check
www.pdftoexcelonline.com
On Apr 21, 6:57 am, ashish kumar gupta wrote:
> Dear All,
> Please tell me how can we convert PDF in to Excel format & should not be
> change format of PDF format.
>
> Thanks,
> Ashish kumar gupta
> phone 9540010417
--
-
I pulled your answer from URL listed below, second and third post both
give different approaches depending on your needs. Below protects and
unprotects all sheets, if you just need one sheet there are other
options in the following URL.
http://www.ozgrid.com/forum/showthread.php?t=20766&page=1
Di
On my response I screwed up the 24 hour time format! Should be 21:00
instead of 17:00.
On Mar 30, 1:17 pm, "STDEV(i)" wrote:
> Try this formula
>
> =IF((B2>=7/24)*(B2<=9/24),"NO","YES")
>
> On Wed, Mar 30, 2011 at 6:53 PM, wrote:
> > Hi All,
>
> > I need formula to update column C, value if the
You can use this formula, make sure to change C6 to the cell your data
is located.
=IF(AND(C6>TIMEVALUE("07:00"),C6 Hi All,
>
> I need formula to update column C, value if the time is between 7:00 AM to
> 9:00 PM "YES" else "NO"
> Find attached for the same.
>
> Column A Column B C
You can use this formula, make sure to change C6 to the cell your data
is located.
=IF(AND(C6>TIMEVALUE("07:00"),C6 Hi All,
>
> I need formula to update column C, value if the time is between 7:00 AM to
> 9:00 PM "YES" else "NO"
> Find attached for the same.
>
> Column A Column B C
If you can change the format of your times it should work. I used
hh:mm:ss and it works.
On Mar 28, 6:59 am, Bhushan Sabbani wrote:
> Dear All,
>
> I am facing the problem in the formula of the large to find the top 10.
>
> Here i am attaching the sample file for the reference.
>
> Thanks in adva
In the top sticked post is the answer to your question.
http://groups.google.com/group/excel-macros/browse_thread/thread/a18c465d411d0138
Also a quick search of already posted query's will net you several
answers
http://groups.google.com/group/excel-macros/browse_thread/thread/903df336db00c77b
h
Simply searching the group for pdf to excel would've given you several
potential answers. I did not check this URL but here is one possible
software answer.
Link to answer:
http://groups.google.com/group/excel-macros/browse_thread/thread/b6fae3eee31606ec/d32d131c316fa8d4?lnk=gst&q=pdf+to+excel#d32
Send an email with the subject being what you need help with (title)
to: excel-macros@googlegroups.com, and then attach file.
On Feb 23, 5:30 am, кαяαηη yα∂αν wrote:
> Hi..Experts,
>
> I need your help.I am unable to attach my file. Pls tell me where
> I can attach file.
>
> Thnx
>
> Karan
-
Can you send a sample file?
On Feb 22, 9:00 am, vinu wrote:
> Hello Team,
>
> I need code on the below scenario:
>
> I have data dump which contains 15 columns of data. I need code to
> perform the below steps:
> Col A(Region), Col D(country), Col J(comments). For eg I filter the
> Col A (Region
Send an email to "excel-macros@googlegroups.com" and attach your file.
Use the subject for the title of your post.
On Feb 2, 1:59 am, Bhushan wrote:
> Hi Expert,
>
> PLease assist me how can attach sample excel file to the new post.
>
> There is no link avaliable which can upload my sample file f
You can choose whichever cell you'd like and insert the following
formula.
=ReturnComputerName()
On Jan 6, 12:24 pm, Rajesh K R wrote:
> Hi
> Thanks for the mail, let me know one thing how can get the result in
> sheet 1! range"A1"
> Regards
> Rajesh kainikkar
Private Declare Function GetComputerName Lib "kernel32" _
Alias "GetComputerNameA" _
(ByVal lpBuffer As String, nSize As Long) As Long
Function ReturnComputerName() As String
Dim rString As String * 255, sLen As Long, tString As String
tString = ""
On Error Resume Next
sLen =
I believe you just need to set the locked object on your item (already
done in your sheet), and then put protection on the sheet. (Tools|
Protection|Protect Sheet)
On Dec 22, 7:08 am, Chandra Shekar
wrote:
> Hello,
>
> How to lock the object? User should not edit the object or delete the
> object
Z are Chr(65-90) M = Chr(77)
> ' Lower Case a-z are Chr(97-122) m = Chr(109)
> On Error Resume Next
> Err.Clear
> ActiveSheet.Name = Mvt & " " & DocDate
> If (Err.Number > 0) Then
> ' Attempt Letters B-M
> For inx = 66 To 77
>
Paul,
I have a another other question (excluding the previous one listed
here in previous post).
Sometimes the movement number has a single space between the letters
and numbers that make up the flight number. Is there a way to include
this information after the space (Total space will never exc
I'm not as good at VBA as I'd like to be and I especially thank you
for taking the time to explain each step, I found it very helpful!
Pertaining to the unique name problem, I looked but was unable to find
a way to add a letter at the end of the date, starting with B going up
to M (though if I get
I'm not as good at VBA as I'd like to be and I especially thank you
for taking the time to explain each step, I found it very helpful!
Pertaining to the unique name problem, I looked but was unable to find
a way to add a letter at the end of the date, starting with B going up
to M (though if I get
Not sure how the computer program works, but you can use the below
code to suppress errors if using a macro.
Application.DisplayAlerts = False
Be sure to use this at the end.
Application.DisplayAlerts = True
On Sep 21, 5:27 am, vikas gupta wrote:
> DEAR ALL
>
> SOME DAYS BEFORE I HAVE INSTALL
What is your problem? You need to give more information in order to
receive help.
On Jul 27, 9:02 am, Venkatesh Narla wrote:
> Dear All,
> I have problem in 2007 Excel Pivot table
> Pls find the Pictures.
>
> Best Regards,
> Venkatesh narla,
> 9886058917
>
> $11174984F06E120B.bmp
> 666KViewDownl
Open a new message, in the tool bar (same row as the send button) is
the options tab, click. A new screen will open and you can check under
delivery options do not deliver before a set time.
>From what I know, Outlook must be left open for it to send. Someone
else may know differently though. I'v
east
>
> Can you send a sample sheet to the group
>
> People will be able to help you a bit faster by looking at it
>
> Cheers
>
> Harry
>
> On Jun 8, 4:59 pm, JsinSk wrote:
>
> > Hello All,
>
> > At my workplace we have a report that is run every
may be to some extent atleast
>
> Can you send a sample sheet to the group
>
> People will be able to help you a bit faster by looking at it
>
> Cheers
>
> Harry
>
> On Jun 8, 4:59 pm, JsinSk wrote:
>
> > Hello All,
>
> > At my workplace we have a re
Hello All,
At my workplace we have a report that is run every 15 minutes, it
takes an employee nearly all of those 15 minutes to process and report
the data to the group. I'm looking for a way to help automate this
somewhat for the employee so he can work on other tasks through the
day as well.
B
activecell.offset(1,0).select moves down one ROW
> not to the right one COLUMN
>
> Paul
>
> ____
> From: JsinSk
> To: MS EXCEL AND VBA MACROS
> Sent: Tue, April 13, 2010 11:18:08 PM
> Subject: $$Excel-Macros$$ Move from column a to b to c in
Hello again friends, I am cannot figure out how to make this work the
way I want :(
I need this to run in column a, then b, then c... but cannot figure
out how to do it. Can someone please help with this matter. I'm sure
it's a very simple solution!
Sub Macro1()
ActiveCell.Offset(-1, 0) = 1
Do
Thanks you two, I integrated both suggestions into my vba and it
processed instantly. Very helpful :)
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
Hello all fellow fellow Macro friends :)
I have a short bit of code that I was wondering if it's possible to
make it run more efficiently. When it runs currently it takes up to 1
minute which seems like a long time.
Notes: This is designed to remove an entire row if the condition is
met. There is
Post the file here and someone will crack it for you.
On Feb 19, 9:24 am, sunil sasidharan
wrote:
> *Hi All,*
> **
> *I need to edit an excel macro file but the VBA coing is protected and
> nobody is aware of the password.*
> **
> *Could you please help me on how do i crack the excel password or
You will need to search the internet for options to get the password.
There are prices to pay. Depending on what kind of data is in your
workbook you could post a link to it, or email it to someone who can
assist.
On Jun 27, 3:47 pm, hanumant shinde wrote:
> Please help me to recover my excel wo
if (instr(1,cells(I,2),"(1;22)") > 0) then cells(i,1) = ""
> next I
>
> is that the kind of thing you're looking for? or did I misunderstand
> completely?
>
> Paul
>
>
> From: JsinSk
> To: MS EXCEL AND VB
I have a excel sheet that I put data primarily into Columns A and B
only.
Column A gets data manually entered into based on what data is in
Column be right next to it.
After I go through the data and run another Macro, I sometime need to
change what's in Column A, based on whats in column B.
Ima
39 matches
Mail list logo
