Bit of excel help?

WhiteCobra

WhiteCobra

WhiteCobra

Associate
Joined
23 Mar 2008
Posts
275
Work has assigned me a task of saving them time by automating a report... They've got their own excel spreadsheet of production infortmation... They then have another sheet, with most of the data which is on the production spreadsheet, which is a pretty report for their customers.

They want the ability to click a button and this pretty report will fill it self :)

On the production information each product has it's own row.. So basically i was thinking of recording a macro of me copying a single row... And then maybe figure out a way of asking the user "What row to copy" and use their number entered in the macro's...

Does this sound possible? Or is there a much easier way im missing?

Thanks :)
 
Yeah. Basically as of now they've been typing out the data practically twice.. Which they want to eliminate... So basically she'd type the data into the production sheet and then wants this data to magically appear in the report sheet :)
 
The production sheet is in a separate file from the pretty version...

The production sheet is being added to every day as new productions are made... Each product has it's own row.

The pretty is used when the customer requests a report on their production. This report will obviously only contain 1 of the productions from the production sheet... This is why the row used will change constantly.. So i need some macro that will change what row it will copy from depending on what the user enters..



The reason for having 2 seperate sheets is that the pretty sheet leaves out certain info the customer doesnt need to see
 
I was thinking of keeping the template of the pretty sheet in a seperate tab on the production file to make life easier.. And then making a quick macro button to export that tab to a seperate work sheet
 
You must log in or register to reply here.
Back
Top Bottom