Hi
the missing answer is probably caused by an unclear
specification :-)
After rereading your post and looking at your attached
file the following is not clear:
1. For me your attached file DOES not match your
description. Not sure what sheet1/sheet2 is and how your
cell/column locations match with them
2. Please be more precise with your range naming. e.g.
- what is column A6ß This is a single cell. So you either
have column A, Row 6 or cell A6
- also D1, E1, F1: didn't found any customer number on
your sheets
3. Expected result:
- if you say you want 'Column B2, I want to transfer the
currencies of (sheet1 D4,E4,F4)' what do you mean with
this?
- also range naming is unclear
-HOW do you want to combine the data
So please re-state your problem :-)
and if you attach a file (which most people won't open)
please try to match it with your description. e.g. show
the source sheet and describe / create a test expected
result sheet (with explanation).
-----Original Message-----
Hi Everyone,
I have requested here under mentioned VBA yesterday, I
have not
received any idea or any help, don't why. I just want to
know if this
is possible in VBA. I am attaching the file to give an
idea.
===================================
I need a VBA tha create and transfer the data of sheet1
to sheet2 as
followd:
Datashee1:
Sheet1
ColumnA6,B6,C6; I have the data
Column D1,E1,F1; I have customers numbers, D4,E4,F4 the
currencies of these customers.
And columns D6,E6,F6 have the prices of these differente
customers.
Sheet2
I need to transfer these data in sheet2 as follow:
Column A2, I want a fix data which is "20"
Column B2, I want to transfer the currencies of (sheet1
D4,E4,F4).
Column C2, I want to transfer the customers numbers
(sheet1
D1:AC1).
Column D2 & E2, I want to transfer the data of (Sheet1 B6
& C6).
Column F2 & G2, I want to create the fix Start & End date.
If you could have a macro to transfer, I will be greatly
thankful.
Thanks in advance.
Attachment filename: create&transfer the data sheet1 to
sheet2.zip
Download attachment:
http://www.excelforum.com/attachment.php?postid=617213
---
Message posted from http://www.ExcelForum.com/
.