| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
copy/print specific data
Hi,
on 'sheet 1' I have several lines of data which is added to all the time. What I want to do is select all the last data entered and paste this into seperate cells on a seperate sheet. eg the last data entered on sheet 1 is held from cells b1-b10 I want to take the data from cell b1 and paste this into 'sheet2' cell ref d30, then the data from b2 on sheet 1 into cell ref f23 on sheet 2, and so on. Once all my selected data has been pasted into my new sheet I wish then to print it on my selected printer, can this be done in VB, if so how many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| How do I take data entries and assign them to specific cells that. | Excel Discussion (Misc queries) | |||
| Getting specific data from a word document into an excel sheet | Excel Worksheet Functions | |||
| How do I retrieve data (specific cells) from multiple worksheets on a shared drive | Excel Worksheet Functions | |||
Threaded Mode
