Macro to copy only some certain cells

[ajay2801]

Hi All,

I want to create some reports and for that i need one macro to select some cells.

for example, i have one workbook, shift report.xlsm and in this workbook i have two Worksheet 1) Dashboard 2) Service Call

in the service call worksheet, i have some Value in B5 cell for example 10.

i want to create macro to copy the data start from Cell A10 to till the value to cell B5.

and paste that data to Worksheet Dashboard at B19. and copy only the value not the formulas.

Hope I'm clear.....

Thanks
Ajay

[arlu1201]

Why dont you explain with the help of some sample files?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[ajay2801]

Thanks for your reply.

file is attached here.

Cheers...

Ajay