URGENT ::Macro for copying a data from sheet1 and pate into another sheet in spc cell

So in reality, these are 2 separate files itself right? Or 2 sheets in the same file?

If they are 2 separate workbooks, will the destination file be open at the time of running the macro or should the macro open it, copy the contents and then save and close it?

CW single has 1 form in it, while the data tab has multiple rows. So should the 1st sheet be copied for each row of data and then the data input?

No, you are not understanding my question. I will rephrase - do you need separate sheets to be created? 1 for each row of data?

Ok, can you quickly tell me which cell from the data sheet should go to which cell in the CW_Single file?

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button

A subscript out of range error occurs when the sheet name in the code does not match the sheet name in the file. Check that both match with regard to spelling and case and run the macro again.

Which code line is highlighted?

Check that your workbook is named data.xlsx and its open at the time of running the macro.

I have changed teh file name..!!

But thing is that, After running the code, The data's(which i want to copy paste ) Are filled in teh workbook (data) itself, With creating a new sheet in the same workbook.

I want to fill teh form,LIke in teh CW single.

Needs to create a new work book in the format of CW single.

Thanks,
Safi.

Have you put the code in the CW single file or in the data file? The code needs to go to the CW Single file.

You mean you want new workbooks having 1 sheet to be created for each row of data in the "data" file?

Yes, You have got the point

ANd also i have found an error al the infrmation on the subsheets in teh CW single are having the same value except teh NUmber.

Thanks,
Safi

Try this code

Please Login or Register  to view this content.

I didnt get you.

Did you put it correctly as ?

Please Login or Register  to view this content.

Oops. Ok, just change the .xlsx to .xls in the entire code.

Its Awesome...!!!

Working Good, One more thing you have to do..

IM were using a macro for sending a mail for these created files.

My Macro is below

Whether i can able to include thsi ??

[

Please Login or Register  to view this content.

]

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

I have not tested it but try this

Please Login or Register  to view this content.

I thought your email code was a working code. You will need to open each file from the folder and get it emailed. Will try and work it out for you.

What do you mean by filename has changed?

Yes. I have asked for a little help from some experts to sort out the mailing part. I have never worked on it, so am stuck. You should receive some help soon.

Arlu,

You are my only hope, Please sort the belwo too.

in teh CW single form B14 and B18 values i have amended teh code to fill teh details from other sheet.

I want to fill one more cell Can you help me ?

if B14 contains OPAL H14 will be 820 the same for B18.

i have given the list of possible B14 and B18 values. Can you finish it too ?
B14 & B18
OPAL - 820
BT - 001
SKY - 822
TELEWEST - 135
NTL - 825


Is that posible to be ?

My recent code is:

Please Login or Register  to view this content.

Im Looking forward to hear from you.

Many thanks,
Safi.

So Safi,

only the points in post 40 are pending, right? Everything else solved?

The files are already being saved through this line of code -

Please Login or Register  to view this content.

if B14 contains OPAL H14 will be 820 the same for B18.

i have given the list of possible B14 and B18 values. Can you finish it too ?
B14 & B18
OPAL - 820
BT - 001
SKY - 822
TELEWEST - 135
NTL - 825

H14 in the newly created files should be changed to the corresponding values you have given here?

So one folder for each file to be saved?

Actually your question has increased from one small task to such a big task . Ideally you should have opened a new thread for each new part.

Nevertheless, try this updated code -

Please Login or Register  to view this content.

Am glad its working.

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

Arlu,

Unfortunately, i have tried to run the macro again.

But it gives an error.

Line Highlighted :MkDir ("\\ad\wwc-ps-17\ps-17\Y129889\home\desktop\test\" & sname & "\")
Error Code :75
i could not find what is teh issue is

Can you please advise ?

Thanks,
Safi.

Morning Kcarley,

I ahve tried in some other locations, but still teh issue presist.

Its making the file and folder but the Mail does't sent.

Plesea can you have an look on thsi please ?

I reckon that the whatever the values in the row, its making the form but doesnt mailing.

Coudl you help me now ?


Many thansk,
Safi.