cros@googlegroups.com
Sent: Fri, February 11, 2011 5:23:19 AM
Subject: Re: $$Excel-Macros$$ build a database from multiple workbooks
Any help. :-) will be appreciated.
--- On Thu, 1/27/11, Seba wrote:
>From: Seba
>Subject: Re: $$Excel-Macros$$ build a database from multiple workbook
Any help. :-) will be appreciated.
--- On Thu, 1/27/11, Seba wrote:
From: Seba
Subject: Re: $$Excel-Macros$$ build a database from multiple workbooks
To: "MS EXCEL AND VBA MACROS"
Date: Thursday, January 27, 2011, 9:23 PM
Hi,
I made the following change for sheet name and
; >> 'Workbooks(Range("a" & i).Value).Windows(1).Visible = False
> > > > >> ASK3.Activate
> > > > >> Sheets(PRIPRAVA_PROJEKTA).Select
> > > > >> Workbooks.Open Filename:=Sheets(PRIPRAVA_PROJEKTA).Range("a" &
veCell.SpecialCells(xlLastCell).Select
>
> > > >> N = ActiveCell.Row
> > > >> If N >= 2 Then
> > > >> Rows("1:" & N).Select
>
> > > >> Selection.Copy
>
> > > >> 'Sheets.Add After:=Sheets(
Sheets(Sheets.Count)
> > >> ask.Activate
> > >> ask.Sheets(1).Activate
> > >> Sheets(1).Select
> > >> Range("A1").Select
> > >> ActiveCell.SpecialCells(xlLastCell).Select
> >
> > >> z = ActiveCell.Row + 1
> >
>
>> 'Exit Sub
> >> Application.DisplayAlerts = True
> >> End Sub
>
> >> ---------
> >> regards
> >> seba
>
> >> On 27 jan., 16:44, ashish koul wrote:
> >> > shannur can you attch the sample workboo
Jan 27, 2011 at 9:13 PM, ashish koul
>> wrote:
>> >
>> > > use 2 for second sheet or 3 for 3 rd sheet like
>> > > sheets(2).select or you can also sheets("abc").select
>> >
>> > > Workbooks.Open Filename:=Sheets(1).Range(&q
ish,
> >
> > >> Life and death matter, I have a workbook and again it has diff sheets
> like
> > >> sheet 1 to sheet 11. and now my task is to copy unique names from
> sheet 1
> > >> search in other sheets if it is existing then I need to copy o
t;
> >> Hi Ashish,
>
> >> Life and death matter, I have a workbook and again it has diff sheets like
> >> sheet 1 to sheet 11. and now my task is to copy unique names from sheet 1
> >> search in other sheets if it is existing then I need to copy only those r
name of the person
>>
>> Regards,
>> Shannur
>>
>> --- On *Thu, 1/27/11, ashish koul * wrote:
>>
>>
>> From: ashish koul
>>
>> Subject: Re: $$Excel-Macros$$ build a database from multiple workbooks
>> To: excel-macros@googlegroups.c
t; from the diff sheets and create a fresh new workbook and name the workbook
> with that name of the person
>
> Regards,
> Shannur
>
> --- On *Thu, 1/27/11, ashish koul * wrote:
>
>
> From: ashish koul
>
> Subject: Re: $$Excel-Macros$$ build a database from multiple
name the workbook with
that name of the person
Regards,
Shannur
--- On Thu, 1/27/11, ashish koul wrote:
From: ashish koul
Subject: Re: $$Excel-Macros$$ build a database from multiple workbooks
To: excel-macros@googlegroups.com
Date: Thursday, January 27, 2011, 2:10 PM
On Thu, Jan
Hi,
it works and it is ok to copy to sheet 1. However I am not able to
define from which sheet to copy from. Could you please indicate in the
code where am I suppose to insert the name of the sheet to copy from.
I didn't see any yellow markings in the code above.
I decided to combine this macro w
hi
try this code if the sheets postion or names are fixed from which data is to
be merged in all workbooks
then simply change below yellow marked line currenty it will copy on sheet
1 from all the workbooks.
2nd - once you get all the file names to be merged you can manually delete
that row, fr
Hi Ashish,
I can't thank you enough for this great solution:)
I'd hate to be a pain in the neck but I do have a couple of questions
more.
Would it be possible to specify only one sheet to be merged? My
workbooks contain several, but only one is relevant for the database.
And, if I run this macro
On Thu, Jan 27, 2011 at 11:37 AM, ashish koul wrote:
> Sub consolidatefromdifferentworkbooks()
>
> Application.DisplayAlerts = False
> 'On Error GoTo abc
> Dim ask As Workbook
> Dim ask2 As Workbook
> Dim ASK3 As Workbook
> Set ASK3 = ActiveWorkbook
> Dim i As Long
> Dim j As Long
> Dim N, z, r,
Sub consolidatefromdifferentworkbooks()
Application.DisplayAlerts = False
'On Error GoTo abc
Dim ask As Workbook
Dim ask2 As Workbook
Dim ASK3 As Workbook
Set ASK3 = ActiveWorkbook
Dim i As Long
Dim j As Long
Dim N, z, r, s, k, d As Long
s = 1
k = 1
Dim x As String
Dim temp As String
Dim sh
Hi guys,
Could you please share us the coding especially when helping... it
really help to improve those being helped (especially me) to understand
the vba macro/coding. Sometimes when I try to open the module/code, it's
protected by password :(
Nonetheless, thanks for the help.
On 1/26/20
copy the data is pretty simple.
>
> Let me know what approach you'd like to take and I'd be glad
> to help put together the macro.
>
> Paul
>
>
> From: Seba
> To: MS EXCEL AND VBA MACROS
> Sent: Wed, January 26, 2011 5:52:59 AM
>
Sent: Wed, January 26, 2011 5:52:59 AM
Subject: Re: $$Excel-Macros$$ build a database from multiple workbooks
Hello,
how can I upload the file, as I see in the notification, this is no
longer possible.
However, if you can imagine my situation:
I have data in columns from A to O and in rows from 1 t
try this macro see if it helps
On Wed, Jan 26, 2011 at 4:22 PM, Seba wrote:
> Hello,
>
> how can I upload the file, as I see in the notification, this is no
> longer possible.
>
> However, if you can imagine my situation:
>
> I have data in columns from A to O and in rows from 1 to 100. The d
Hello,
how can I upload the file, as I see in the notification, this is no
longer possible.
However, if you can imagine my situation:
I have data in columns from A to O and in rows from 1 to 100. The data
is in the same rows and columns in all workbooks.
Now I need the data to be copied from all
send us the sample workbook
On Mon, Jan 17, 2011 at 12:10 AM, Seba wrote:
> Hello all,
>
> I have a question regarding building a database. I have a workbook for
> each of my projects. I would like to have a macro, which would extract/
> copy certain data (always in the same rows and columns) to
Hello all,
I have a question regarding building a database. I have a workbook for
each of my projects. I would like to have a macro, which would extract/
copy certain data (always in the same rows and columns) to a new
workbook, which would serve as a database.
Could anyone please help?
Thank yo
24 matches
Mail list logo
