Copy non blank data from one worksheet to another

**VIJAY48** · 01-29-2012, 10:58 AM

I want to copy non blank cells from each columns in stock sheet and copy to order sheet under respective heads as shown in my attached file.

I need a macro for this.

Please help.

Rgds

Vijay

**royUK** · 01-29-2012, 11:48 AM

I can't see what you criteria are

**rscsmith** · 01-30-2012, 01:27 AM

Hi there

I think the attached does what you need.

Cheers, Rob.

**VIJAY48** · 01-31-2012, 12:47 PM

Hi Smith

Thanks a lot

Vijay.

**VIJAY48** · 02-02-2012, 06:14 AM

Hi Smith

I just want to refine the solution you have given me. Is it possible that the data in the stock sheet can be copied (only active cells in a column) to order sheet as per the format i have attached with totals, running order nos. and current date.

Please help.

Regards,

Vijay.

**rscsmith** · 02-02-2012, 05:02 PM

Hi Vijay

Does the header information always stay the same for each company (e.g. Anupam is always XTC/KL/13666/ORDER/1799, Dest EDAPALLY, etc)?

If not, I will need to know how the order number relates to the data. If there is another spreadsheet you have with order number and Party Name, Destination, Thru, please could you provide this? The data will need to be in a table on a separate sheet of this spreadsheet so it can be retrieved and put in the header of your new format.

I guess the Material Description the same as Bearing No., and Code the same as Material?

Cheers, Rob.

**VIJAY48** · 02-04-2012, 07:36 AM

HI Smith,

Thanks for your reply.

I have attached the spreadsheet with a separate sheet 'Master' as you requested. If any new party is added to stock sheet and master sheet i should be able to extract the data as required including the new party.

Kindly let me know anything else is required. If a solution is found i will be verymuch thankful to you.

Regards,

Vijay.

**VIJAY48** · 02-07-2012, 01:41 PM

HI

Can anybody help on this issue

Vijay

**rscsmith** · 02-07-2012, 10:24 PM

Hi Vijay

Apologies for the delay - been busy with other things. Here is what you asked for.

Cheers, Rob.

**VIJAY48** · 02-13-2012, 07:42 AM

Hi Smith

Fantastic work man. I got the thing i want. It works. Sorry i was just working with the same file with some changes as in need and it worked. That's why there is delay in thanking you. Thanks a lot.

But i will be in touch with you for other similar jobs if you dont mind.

Regards,

Vijay.