creat and transfer data sheet1 to sheet2

[John12]

Hi Everyone,


I have requested here under mentioned VBA yesterday, I have no
received any idea or any help, don't why. I just want to know if thi
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.zi
Download attachment: http://www.excelforum.com/attachment.php?postid=61721

 

[Frank Kabel]

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).

 

[John12]

Hi,

My apology if I haven't provided a clear description to the request.
Let's put figure "20" out of request.
In column B2 (upload sheet=sheet that the VBA should creat
automatically), I need to transfer the cells F14:AC14 of (Mark-u
sheet)
in column C2 (upload sheet), transfer cells F8:AC8 (Mark-up sheet)
depending the numbers of rows in each columns starting from F19
currently column F consist 15 rows. Need to transfer 24 time each cel
from F8.
In column D2 (upload sheet), I need to transfer cells B19:B3
recurring, should be 24 time.
In column E2 (upload sheet), need to transfer cells F19:AC1
(recurring).
Let's also put out of scope the dates.

Again, my apology if I have waste your time.
Let me know If I've made another mistake.

Thanks in advance.


Regards