I have a workbook contains 257 sheets of which 255 sheets are database
sheets,1 data download sheet and other one is query/report sheet.Everyday I
download a page (in excel format) from net (to data download sheet),contains
around 3000 records(3000 rows),from which I select 255 records and manually
updates my workbook(copy and paste).This takes about 2 to 3 hours for me to
update my workbook.my 255 sheet names are cloumn 'A' values of downloaded
page, and all column headings of my worksheets matches with col.headings of
downloaded page.In short I am matching each of my sheetname with col A:A of
data download sheet and copying that row values and pasting them in my
worksheet(last row).After updating all of my 255 sheets,I delete contents of
data download sheet for tomarrows download.Can this task be automised through
a macro,which will help a great.I am giving an example below
downloaded page(sheet):
company name. prclose open high low close totalval totalqty date
RIL 614 615 618 611 617 123456 25416
30NOV2005
CIPLA 265 266 268 258 263 325644 18254
30NOV2005

My workbook/RIL sheet
date open high low close
26 29NOV2005 611 618 610 614 (this is my last row)
27 (this row values are to be updated,copy from above sheet and pasting)


RIL/CIPLA/GLAXO(these are sheet names)

You would

loop through each sheet;
loop for data
using sheet name as vlookup value to get data from download sheet (four
of them, one by one);
tuck this data to the bottom of the relevant column in the sheet;
this is getting data loop;
loop next sheet

clear contents of download sheet



"TUNGANA KURMA RAJU" wrote in
message ...
I have a workbook contains 257 sheets of which 255 sheets are database
sheets,1 data download sheet and other one is query/report sheet.Everyday
I
download a page (in excel format) from net (to data download
sheet),contains
around 3000 records(3000 rows),from which I select 255 records and
manually
updates my workbook(copy and paste).This takes about 2 to 3 hours for me
to
update my workbook.my 255 sheet names are cloumn 'A' values of downloaded
page, and all column headings of my worksheets matches with col.headings
of
downloaded page.In short I am matching each of my sheetname with col A:A
of
data download sheet and copying that row values and pasting them in my
worksheet(last row).After updating all of my 255 sheets,I delete contents
of
data download sheet for tomarrows download.Can this task be automised
through
a macro,which will help a great.I am giving an example below
downloaded page(sheet):
company name. prclose open high low close totalval totalqty date
RIL 614 615 618 611 617 123456 25416
30NOV2005
CIPLA 265 266 268 258 263 325644 18254
30NOV2005

My workbook/RIL sheet
date open high low close
26 29NOV2005 611 618 610 614 (this is my last
row)
27 (this row values are to be updated,copy from above sheet and pasting)


RIL/CIPLA/GLAXO(these are sheet names)

Thank you for suggesting me the basics for vba code for this task,but I am
not having basic knowledge to write code.I am new learner in Excel.Can you
please give me complete code for this task.I shall be greatful if you help me.

"PY & Associates" wrote:

You would

loop through each sheet;
loop for data
using sheet name as vlookup value to get data from download sheet (four
of them, one by one);
tuck this data to the bottom of the relevant column in the sheet;
this is getting data loop;
loop next sheet

clear contents of download sheet



"TUNGANA KURMA RAJU" wrote in
message ...
I have a workbook contains 257 sheets of which 255 sheets are database
sheets,1 data download sheet and other one is query/report sheet.Everyday
I
download a page (in excel format) from net (to data download
sheet),contains
around 3000 records(3000 rows),from which I select 255 records and
manually
updates my workbook(copy and paste).This takes about 2 to 3 hours for me
to
update my workbook.my 255 sheet names are cloumn 'A' values of downloaded
page, and all column headings of my worksheets matches with col.headings
of
downloaded page.In short I am matching each of my sheetname with col A:A
of
data download sheet and copying that row values and pasting them in my
worksheet(last row).After updating all of my 255 sheets,I delete contents
of
data download sheet for tomarrows download.Can this task be automised
through
a macro,which will help a great.I am giving an example below
downloaded page(sheet):
company name. prclose open high low close totalval totalqty date
RIL 614 615 618 611 617 123456 25416
30NOV2005
CIPLA 265 266 268 258 263 325644 18254
30NOV2005

My workbook/RIL sheet
date open high low close
26 29NOV2005 611 618 610 614 (this is my last
row)
27 (this row values are to be updated,copy from above sheet and pasting)


RIL/CIPLA/GLAXO(these are sheet names)

We attended to other business opportunities and did not follow up on this
news group.

Considering the amount of time and labor Excel VBA automation can save you,
and if you have not got it done, we would recommend you contract any service
provider to code it for you immediately please.

"TUNGANA KURMA RAJU" wrote in
message ...
Thank you for suggesting me the basics for vba code for this task,but I am
not having basic knowledge to write code.I am new learner in Excel.Can you
please give me complete code for this task.I shall be greatful if you help
me.

"PY & Associates" wrote:

You would

loop through each sheet;
loop for data
using sheet name as vlookup value to get data from download sheet
(four
of them, one by one);
tuck this data to the bottom of the relevant column in the sheet;
this is getting data loop;
loop next sheet

clear contents of download sheet



"TUNGANA KURMA RAJU" wrote
in
message ...
I have a workbook contains 257 sheets of which 255 sheets are database
sheets,1 data download sheet and other one is query/report
sheet.Everyday
I
download a page (in excel format) from net (to data download
sheet),contains
around 3000 records(3000 rows),from which I select 255 records and
manually
updates my workbook(copy and paste).This takes about 2 to 3 hours for
me
to
update my workbook.my 255 sheet names are cloumn 'A' values of
downloaded
page, and all column headings of my worksheets matches with
col.headings
of
downloaded page.In short I am matching each of my sheetname with col
A:A
of
data download sheet and copying that row values and pasting them in my
worksheet(last row).After updating all of my 255 sheets,I delete
contents
of
data download sheet for tomarrows download.Can this task be automised
through
a macro,which will help a great.I am giving an example below
downloaded page(sheet):
company name. prclose open high low close totalval totalqty
date
RIL 614 615 618 611 617 123456
25416
30NOV2005
CIPLA 265 266 268 258 263 325644
18254
30NOV2005

My workbook/RIL sheet
date open high low close
26 29NOV2005 611 618 610 614 (this is my
last
row)
27 (this row values are to be updated,copy from above sheet and
pasting)


RIL/CIPLA/GLAXO(these are sheet names)