Hi Group
i m creating a macro by vba but getting some error ...
pls help i want to output in a cell.using below code ..
example atteched..
Private Sub CommandButton1_Click()
Dim sh As Worksheet
Dim rng As Range
Dim i As Integer
Set sh = ThisWorkbook.Sheets(1)
Set rng =
Dear Excel Experts!
Hi,
Once again I need your help regarding subject matter, mentioned above. I
need Data of 527 employees data on other sheet to another proforma through
the help of macros. Which can only be possible if you experts do this for
me. I will be very much thankful to you experts
Dear chandan,
PFA. If you have any concern let me know.
Regards,
Ganesh N
On Tue, Nov 4, 2014 at 3:41 PM, Chandan Bisht csb.bi...@gmail.com wrote:
Hi Group
i m creating a macro by vba but getting some error ...
pls help i want to output in a cell.using below code ..
example
FYI
+
*I did not do this for you. God is here working through me for you.*
-- Forwarded message --
From: Vaibhav Joshi v...@vabs.in
Date: Sat, Nov 1, 2014 at 3:17 PM
Subject: Re: $$Excel-Macros$$ Automatic update excel file from website
To: excel-macros@googlegroups.com
thnks ganesh..working fine..
Chandra Singh Bisht
On Tue, Nov 4, 2014 at 5:01 PM, Ganesh N ganeshg...@gmail.com wrote:
Dear chandan,
PFA. If you have any concern let me know.
Regards,
Ganesh N
On Tue, Nov 4, 2014 at 3:41 PM, Chandan Bisht csb.bi...@gmail.com wrote:
Hi Group
i m
Dear Experts!
Hi,
I have a problem while i copy data from pdf file to excel... it doesn't
copy in same columns rows as shown in pdf file. Therefore please help me
in this regard.
Here i am attaching a pdf file.
Thanks in advance.
__
Muhammad Rafique Ujjan
--
Are you
Hello,
I have been given a task where I have say 10 spreadsheets located on the
network which have the same filename and tab naming convention. Each
spreadsheet will have a tab for each week of the year that contains reports
that I'd like to consolidate. For example, each spreasdsheet will
I'm sure I can put together something that will work cleanly.
Rather than make assuptions though, I'll ask a couple of questions:
in the folder:
C:\Users\test\Desktop\Labour\test
will you be consolidating specific sheets from ALL of the files in this location
(that do now begin with Week..
Here's what I came up with.
Let me know if you need additional explanation.
Option Explicit
Sub Consolidate_Sheets()
Dim ShtNo As String, NewWb, wbName
Dim fPath
Dim Sht, fso, fld, File
Application.ScreenUpdating = False
Hello!
With regards to consolidation file location point, yes that path
(C:\Users\test\Desktop\Labour\test) is where I'd like the file to be saved
to in the end.
As for the source files if you will, (aka the files maintained by
stores). These files will be saved in different folders on the
Since the files will be in different locations,
you can list them in column B like:
C:\temp\Users\test\Desktop\Labour\test\11000.xlsx
C:\temp\Users\test\Desktop\Labour\test\11001.xlsx
C:\temp\Users\test\Desktop\Labour\test\11002.xlsx
C:\temp\Users\test\Desktop\Labour\test\11003.xlsx
Hi Group
Please find attached file,
i am locking for formula like vlookup function. Pls help i want to
output value come in next cell like vlookup.
example attached..
--
__
Thanks Regards,
Bholanath Verma
M +234 8141 337 555
E: bholanathve...@gmail.com
gtalk ID:
Hi Sanjay
use this function
=IF(COLUMN()-2=0,IFERROR(LEFT($A18,FIND(|,$A18)-1),$A18),IFERROR(MID($A18,FIND(~,SUBSTITUTE($A18,|,~,COLUMN()-2))+1,IFERROR(FIND(~,SUBSTITUTE($A18,|,~,COLUMN()-1))-1,LEN($A18))-FIND(~,SUBSTITUTE($A18,|,~,COLUMN()-2))),))
Regards,
Anil Kumar Maurya
Hi
pfa
Regards,
Anil Kumar Maurya
On Tuesday, 4 November 2014 4:50 PM, M.Rafique MRU
imrafiqu...@gmail.com wrote:
Dear Excel Experts!
Hi,
Once again I need your help regarding subject matter, mentioned above. I need
Data of 527 employees data on other sheet
Great, that´s just perfect! Thank you very much!
What if the initial row with the text to be copied should be deleted after
it has been copied?;)
I would appreciate if you could help me with this too!
Regards
Iva
Dne pondělí, 3. listopadu 2014 8:38:25 UTC+1 Vabz napsal(a):
Iva
Check this,
Hello! I have a problem with this document. I make some simple calculations
of ranges but in the last step when I need to get the results I get an
error. can someone check the VBA adn find the problem?Thank you
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
just use Adobe Acrobat XI pro, it may convert your pdf into excel
On Tuesday, 4 November 2014 17:36:21 UTC+5, MRafique Ujjan wrote:
Dear Experts!
Hi,
I have a problem while i copy data from pdf file to excel... it doesn't
copy in same columns rows as shown in pdf file. Therefore please
I got an answer at excelforum and thought I should update the link
http://www.excelforum.com/excel-programming-vba-macros/1047574-shuffle-four-answers-of-one-question-with-a-condition-and-loop-it.html
Thank you
Sub test()
Dim r As Long
Dim CA As String
For r = 1 To
here you go...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Nov 5, 2014 at 2:00 AM, ivavok ivana.vokrouhlik...@gmail.com
wrote:
Great, that´s just perfect! Thank you very much!
What if the initial row with the text to be copied should be deleted
Thanks for posting.
+
*I did not do this for you. God is here working through me for you.*
On Wed, Nov 5, 2014 at 9:40 AM, Rajnish Malhotra
freeofcosthotels...@gmail.com wrote:
I got an answer at excelforum and thought I should update the link
20 matches
Mail list logo