Copu worksheet ranges from One Workbook to another from

[halem2]

Hi:

I have a workbook with about 250 worksheets, let's call it MW.xls. All worksheets have a name(a1, a2, etc). Once a week I copy groups of worksheets and save them as different workbooks(let's say wb1.xls, wb2.xls). Those workbooks get updated and emailed back to me. I receive about 15 workbooks through email.

I need to copy different cell ranges from the updates workbooks' worksheets (let's say from wb1.xls) to the original one(MW.xls). So if in the emailed workbook I have worksheets a1, a2, a3, I need to copy cell ranges b5:k5 and a7: j10 to the same worksheets in the original workbook(MW.xls).

It is a very tedious process and it is identical for every sheet.

Thank you in advance for any help,

[Marijus]

So here you got an example how to solve your problem.
you have to put all files in one directory and then open master.xls
you will get table
This workbook contains links to other data sources
choose update.
if excel cannot find source so you should go to EDIT | LINKS and there choose Change source and navigate to the file child1.xls and child2.xls


--
M.A.
"halem2" <halem2.256f0r_1143207617.2051@excelforum-nospam.com> wrote in message news:halem2.256f0r_1143207617.2051@excelforum-nospam.com...

>
> Hi:
>
> I have a workbook with about 250 worksheets, let's call it MW.xls. All
> worksheets have a name(a1, a2, etc). Once a week I copy groups of
> worksheets and save them as different workbooks(let's say wb1.xls,
> wb2.xls). Those workbooks get updated and emailed back to me. I receive
> about 15 workbooks through email.
>
> I need to copy different cell ranges from the updates workbooks'
> worksheets (let's say from wb1.xls) to the original one(MW.xls). So if
> in the emailed workbook I have worksheets a1, a2, a3, I need to copy
> cell ranges b5:k5 and a7: j10 to the same worksheets in the original
> workbook(MW.xls).
>
> It is a very tedious process and it is identical for every sheet.
>
> Thank you in advance for any help,
>
>
> --
> halem2
> ------------------------------------------------------------------------
> halem2's Profile: http://www.excelforum.com/member.php...fo&userid=9930
> View this thread: http://www.excelforum.com/showthread...hreadid=526072
>

[halem2]

Maybe I did not explain myself too clearly. I have both workbooks open at the same time and arranged horizontally. I need to compare the worksheet name on one to the ones in the bottom workbook and once it finds it, then copy a range of cells. Move to another worksheet on the top file, find it's counterpart on the bottom file and copy the same range.

then do this for 250 worksheets.

thanks,

[Marijus]

b2ggbm93IGkgdW5kZXJzdGFuZCBhbmQgLi4uIGdpdmUgVVAgIDooDQoNCg0KDQotLSANCk0uQS4N
CiJoYWxlbTIiIDxoYWxlbTIuMjU2Z3ZiXzExNDMyMTAwMDcuNTcwMUBleGNlbGZvcnVtLW5vc3Bh
bS5jb20+IHdyb3RlIGluIG1lc3NhZ2UgbmV3czpoYWxlbTIuMjU2Z3ZiXzExNDMyMTAwMDcuNTcw
MUBleGNlbGZvcnVtLW5vc3BhbS5jb20uLi4NCj4gDQo+IE1heWJlIEkgZGlkIG5vdCBleHBsYWlu
IG15c2VsZiB0b28gY2xlYXJseS4gIEkgaGF2ZSBib3RoIHdvcmtib29rcyBvcGVuDQo+IGF0IHRo
ZSBzYW1lIHRpbWUgYW5kIGFycmFuZ2VkIGhvcml6b250YWxseS4gIEkgbmVlZCB0byBjb21wYXJl
IHRoZQ0KPiB3b3Jrc2hlZXQgbmFtZSBvbiBvbmUgdG8gdGhlIG9uZXMgaW4gdGhlIGJvdHRvbSB3
b3JrYm9vayBhbmQgb25jZSBpdA0KPiBmaW5kcyBpdCwgdGhlbiBjb3B5IGEgcmFuZ2Ugb2YgY2Vs
bHMuICBNb3ZlIHRvIGFub3RoZXIgd29ya3NoZWV0IG9uIHRoZQ0KPiB0b3AgZmlsZSwgZmluZCBp
dCdzIGNvdW50ZXJwYXJ0IG9uIHRoZSBib3R0b20gZmlsZSBhbmQgY29weSB0aGUgc2FtZQ0KPiBy
YW5nZS4gIA0KPiANCj4gdGhlbiBkbyB0aGlzIGZvciAyNTAgd29ya3NoZWV0cy4gIA0KPiANCj4g
dGhhbmtzLA0KPiANCj4gDQo+IC0tIA0KPiBoYWxlbTINCj4gLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQo+IGhh
bGVtMidzIFByb2ZpbGU6IGh0dHA6Ly93d3cuZXhjZWxmb3J1bS5jb20vbWVtYmVyLnBocD9hY3Rp
b249Z2V0aW5mbyZ1c2VyaWQ9OTkzMA0KPiBWaWV3IHRoaXMgdGhyZWFkOiBodHRwOi8vd3d3LmV4
Y2VsZm9ydW0uY29tL3Nob3d0aHJlYWQucGhwP3RocmVhZGlkPTUyNjA3Mg0KPg==

[halem2]

sorry but your answers look like encrypted text such as the one below


b2ggbm93IGkgdW5kZXJzdGFuZCBhbmQgLi4uIGdpdmUgVVAgID ooDQoNCg0KDQotLSANCk0uQS4N
CiJoYWxlbTIiIDxoYWxlbTIuMjU2Z3ZiXzExNDMyMTAwMDcuNT cwMUBleGNlbGZvcnVtLW5vc3Bh
bS5jb20+IHdyb3RlIGluIG1lc3NhZ2UgbmV3czpoYWxlbTIuMj U2Z3ZiXzExNDMyMTAwMDcuNTcw
MUBleGNlbGZvcnVtLW5vc3BhbS5jb20uLi4NCj4gDQo+IE1heW JlIEkgZGlkIG5vdCBleHBsYWlu
IG15c2VsZiB0b28gY2xlYXJseS4gIEkgaGF2ZSBib3RoIHdvcm tib29rcyBvcGVuDQo+IGF0IHRo
ZSBzYW1lIHRpbWUgYW5kIGFycmFuZ2VkIGhvcml6b250YWxseS 4gIEkgbmVlZCB0byBjb21wYXJl
IHRoZQ0KPiB3b3Jrc2hlZXQgbmFtZSBvbiBvbmUgdG8gdGhlIG 9uZXMgaW4gdGhlIGJvdHRvbSB3
b3JrYm9vayBhbmQgb25jZSBpdA0KPiBmaW5kcyBpdCwgdGhlbi Bjb3B5IGEgcmFuZ2Ugb2YgY2Vs
bHMuICBNb3ZlIHRvIGFub3RoZXIgd29ya3NoZWV0IG9uIHRoZQ 0KPiB0b3AgZmlsZSwgZmluZCBp
dCdzIGNvdW50ZXJwYXJ0IG9uIHRoZSBib3R0b20gZmlsZSBhbm QgY29weSB0aGUgc2FtZQ0KPiBy
YW5nZS4gIA0KPiANCj4gdGhlbiBkbyB0aGlzIGZvciAyNTAgd2 9ya3NoZWV0cy4gIA0KPiANCj4g
dGhhbmtzLA0KPiANCj4gDQo+IC0tIA0KPiBoYWxlbTINCj4gLS 0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS 0tLS0tLS0tLS0tLS0tDQo+IGhh
bGVtMidzIFByb2ZpbGU6IGh0dHA6Ly93d3cuZXhjZWxmb3J1bS 5jb20vbWVtYmVyLnBocD9hY3Rp
b249Z2V0aW5mbyZ1c2VyaWQ9OTkzMA0KPiBWaWV3IHRoaXMgdG hyZWFkOiBodHRwOi8vd3d3LmV4
Y2VsZm9ydW0uY29tL3Nob3d0aHJlYWQucGhwP3RocmVhZGlkPT UyNjA3Mg0KPg==

[Ardus Petus]

Copy the following code into a module in MW.xls
Assign a keyboard shortcut to the macro
Select source sheet
Run macro

HTH
--
AP

'------------------------------------
Sub moveIt()
Const rng1 = "B5:K5"
Const rng2 = "A7:J10"
'Assume active sheet is source sheet
With ThisWorkbook.Worksheets(ActiveSheet.Name)
.Range(rng1).Value = ActiveSheet.Range(rng1).Value
.Range(rng2).Value = ActiveSheet.Range(rng2).Value
End With
End Sub
'-------------------------------------------------
"halem2" <halem2.256f0r_1143207617.2051@excelforum-nospam.com> a écrit dans
le message de news:halem2.256f0r_1143207617.2051@excelforum-nospam.com...
>
> Hi:
>
> I have a workbook with about 250 worksheets, let's call it MW.xls. All
> worksheets have a name(a1, a2, etc). Once a week I copy groups of
> worksheets and save them as different workbooks(let's say wb1.xls,
> wb2.xls). Those workbooks get updated and emailed back to me. I receive
> about 15 workbooks through email.
>
> I need to copy different cell ranges from the updates workbooks'
> worksheets (let's say from wb1.xls) to the original one(MW.xls). So if
> in the emailed workbook I have worksheets a1, a2, a3, I need to copy
> cell ranges b5:k5 and a7: j10 to the same worksheets in the original
> workbook(MW.xls).
>
> It is a very tedious process and it is identical for every sheet.
>
> Thank you in advance for any help,
>
>
> --
> halem2
> ------------------------------------------------------------------------
> halem2's Profile:
http://www.excelforum.com/member.php...fo&userid=9930
> View this thread: http://www.excelforum.com/showthread...hreadid=526072
>

[halem2]

Hi:

I tried it but it does not anything.

[halem2]

I don't see where you're telling it to go to the other or second worksheet. I see it picking the values but not where it puts them.

[halem2]

My Mistake. It works beautifully. thanks a million