Hi There,
I am looking for a Macro which copies data from different Excels's
specific sheet into new Excel by appending the same.
These different Excel's are basically a daily report dumped into one
folder.
Will be thankful to you guys if you can provide the macro.
Thanks
Hitesh.
--
-
Hi Sudhir,
I hope the following code will help you out:
"Public Sub Test()
Dim W1 As Worksheet
Dim W2 As Worksheet
'Change the filw name accordingly
Set W1 = Workbooks("Old File.xls").Worksheets("Sheet1")
Set W2 = Workbooks("Latest File.xls").Worksheets("Sheet1")
For I = 2 To 200
Val1 = W2.Ce
Hello all,
I want to add certain quantities in the sheet but it shoud compare the
time scale (in months) specified above and input the given data in
same month. cell. can any one suggest any solution.
Nikhil.
--
--
can some help me to have automated invoice format
--
Thanks
Rajesh
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedI
Hi,
u used
Data--Import External Data-Import Data -Chouse excel file
On Thu, Apr 29, 2010 at 10:10 PM, Hitesh Dhare <
hitesh.dh...@idea.adityabirla.com> wrote:
> Hi There,
>
> I am looking for a Macro which copies data from different Excels's
> specific sheet into new Excel by appendin
Evidently, you're using Excel 2003, so the VBA sort command would look
different than mine in Excel2007.
I recommend that you record a macro,
sort the sheet, then look at the code created.
In Excel2007, it looks like:
Sub SortData()
Cells.Select
ActiveWorkbook.Worksheets("Sample").Sort.
Curious.
I too am using Excel 2007.
I opened a new workbook.
Inserted a FromControl button as well as an Activex button on Sheet1.
Copied the sheet.
Sheet2 has both buttons...
I suspect there's something different in your settings.
First, try it in a new workbook (no others open)
If it works THEN
Lots of questions before we can begin:
are the different reports in one folder really Excel files? or are they ASCII
files
created with Excel extensions?
If they're actually excel files, are there multiple sheets in each file?
do you want one sheet or all?
what version of excel are you using.
Dear Paul Schreiner
Your email are very Informative, I like your way to explain.
:)
On Fri, Apr 30, 2010 at 5:34 PM, rf1234 rf1234 wrote:
> Hello Dear,
> There are many macro available to import specific range.
> I.E
> It is possible to select all xls file in 1 folder,and it will apend all in
Hi Paul,
Thanks for your reply. could you try my clue.
That is find the column number and assign value to it.
Thanks,
Sundarvelan
On Fri, Apr 30, 2010 at 5:01 PM, Paul Schreiner wrote:
> Evidently, you're using Excel 2003, so the VBA sort command would look
> different than mine in Excel2007.
Hi Paul,
There are excel files with different sheet in it. I need to capture details of
specific sheet. Also it is nice if the details are collected without opening
Excel. I am comfortable with VBA and having working experience on Macros in
Excel. I need some basic code so that I can go forwar
Hi Rajesh,
You should provide some more details like which all raw data you have? For
creating automated Invoice Format, we can create 100 types of template but
what are your requirements.
Please be specific with your questions.
On Fri, Apr 30, 2010 at 12:22 PM, Rajesh D wrote:
> can some help
I'm sorry, I don't understand your question.
I was responding to the question regarding sorting columns.
Paul
From: Sundarvelan N
To: excel-macros@googlegroups.com
Sent: Fri, April 30, 2010 8:14:59 AM
Subject: Re: $$Excel-Macros$$ Fwd: Excel Macro : Sorting B
Sorry,
as I said, I've never experimented with the techniques for retrieving data from
Excel files without opening them.
But I've seen several discussion threads regarding these techniques.
Have a look and see if they can help you.
Paul
From: Hitesh Dilipbhai D
Hi Paul/Friends
could u please confirm me without recording macro we cannot do sorting.
could you help me in giving coding for sorting without recording.
Thanks,
Sundarvelan
On Fri, Apr 30, 2010 at 6:46 PM, Paul Schreiner wrote:
> I'm sorry, I don't understand your question.
>
> I was respond
Thanxs dear for spread sheet compare,
there is a problem with this if we add a new row in between two rows than,it
will take all the data in rows below newly added one as a changed in data.
hw can i short out this problem.
thanks.
On Wed, Apr 28, 2010 at 5:48 PM, Tom Jeffries wrote:
> There is
Hi all,
Is it possible or not?
regards,
Vijay
On Tue, Apr 27, 2010 at 1:34 AM, Vijay Aggarwal wrote:
> Hi,
>
> I saved a excel file on share drive. I want that everybody can access that
> file but unable to copy that file or data from that file without my
> permission.
>
> Is it possible? If ye
I have 5 major categories defined, and depending on which category is
chosen, up to 20 sub-categories. How do I embed an "if" statement into
my data validation? Thank you.
--
--
Some important links for excel users:
1
U r always welcome.
Thanks n Best of luck.
DiLipandey
On 4/30/10, vinod rao wrote:
> Hi Dilip,
>
> Exactly, i worked. Thank you very much.
>
> thanks
> Vinod
> On Thu, Apr 29, 2010 at 1:53 PM, Dilip Pandey wrote:
>
>> Dear Vinod,
>>
>> Your desired solution is attached with this email. :)
>>
>>
19 matches
Mail list logo