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
> http://www.excelforum.com/excel-programmi
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
wrote:
> 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 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 Cells(Rows.Cou
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 p
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
=TIME(
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 th
Hi
pfa
Regards,
Anil Kumar Maurya
On Tuesday, 4 November 2014 4:50 PM, M.Rafique MRU
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 to another proforma th
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,
Ani
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: bholanathve
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
C:\temp\User
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
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
'--
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.."
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 ha
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 =EX
thnks ganesh..working fine..
Chandra Singh Bisht
On Tue, Nov 4, 2014 at 5:01 PM, Ganesh N 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 wrote:
>
>>
>> Hi Group
>>
>> i m creating a macro by vba
FYI
+
*I did not do this for you. God is here working through me for you.*
-- Forwarded message --
From: Vaibhav Joshi
Date: Sat, Nov 1, 2014 at 3:17 PM
Subject: Re: $$Excel-Macros$$ Automatic update excel file from website
To: "excel-macros@googlegroups.com"
check this...
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 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 atteched..
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 for
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 = sh.Range("a
20 matches
Mail list logo
