Copy data from selected rows to another sheet.

[Headhunter234]

Hello,

I work for a small print company and they have just taken to using excel to manage quotes/orders/Scheduling but currently they type similar data in to every sheet manually at the moment. Its been a long time since i did anything other than basic formulas in Excel but i offered to take a look with some help from a forum like this one i'm hoping.

So the basic entry sheet consist of a table that holds quote details. It has column for quote number increasing after each record, this also included customer details and job details.
If the job goes live currently they look up the first sheet to find the quote and copy all the relevant information from the 1st sheet into a sheet of live jobs. Some of this data is also copied into a sheet for scheduling purposes with a few additional details added. Thirdly the information is taken into another workbook onto a job template sheet which is saved and printed independently of the main workbook.

So what would be ideal would be if there was someway of having a sheet full of information, which some form of tick box system so that the code would only copy the data from the row/rows selected into the relevant sheets withing the workbook. I have done this with macros before but i could only get it to copy the same row each time.

I'm not sure if this is possible but i would also like to be able to generate a job sheet from the same information but picking up the saved template, either on the end of the workbook which is then removed after to its own workbook or opening the saved template.

I know there's a lot here and i'm quite ambitious but I only plan on helping them out with little bits of improvements at a time.

So if anyone has any pointers on where to start of if would like to see the workbooks currently for a better idea let me know.

Regards
Leon

[Headhunter234]

Had a thought about a possible solution, what about having an additional column with a yes/no option if the column reads yes then data is taken from that row if no then its omitted?

for example is cell in column D is yes copy Cell A(same value as cell in D) to Sheet 2 A(next available row containing no data).

I should be able to edit the code the relevant cells and sheets once I have the basics.

Thanks
Leon

[Headhunter234]

Have Started to code a basic copy and paste method of doing this by using a relative offset macro, but the code is looking really messy is there an easier way to have to use Variable row based being the same row that a cell is selected in and using a fixed column each time.

Also does offset part need to be for both sheets or do i only need that for the copying sheet? The sheet to be pasted will be a new sheet each time so cells being pasted will be fixed.

Have attached files for reference, this is all based on starting in the Quote/Job number column of the given row needed. Added "no data" to the file names, which doesn't show in the macro.

This is what I have so far.

Please Login or Register  to view this content.

[Headhunter234]

Anyone able to help out on this? Or is more info needed?
Regards
Leon