You are here:
I can answer questions regarding good software fit for your organization and needs, tips on how to overcome change resistance, design tips of IT solutions for your business needs, and more. Hire me to work on your project at vWorker.com
I have been working in various roles for over ten years, part of those in the Business side and the other in Information Systems designing IT solutions for firms and planning and executing implementation strategies.
M.Com - Mumbai University, Mumbai, India MS(IT) MBA(IS) Dual Degree - Bentley University, Waltham, MA, USA
| User | Date | K | C | P | Comments |
|---|---|---|---|---|---|
| Shoaib | 03/29/12 | 10 | 10 | 10 | Thanks Shahid....And keep it up like ..... |
| shoaib | 03/27/12 | 10 | 10 | 10 | Thanks Shahid for your valuable time that ..... |
| Shoaib | 03/23/12 | 10 | 10 | 10 | Thank you so much Shahid once again ..... |
| Shoaib | 03/21/12 | 10 | 10 | 10 | Thanks Shahid for giving such kind support ..... |
| Shoaib | 03/14/12 | 10 | 10 | 10 | Thank you very much Shahid now I ..... |
Hi, Try this... If rng <> Nothing Then If Left(rng.Value, 1) <> "0" Then trg.Cells(65536, 1).End(xlUp).Offset(1).Resize(rng.Rows.Count, rng.Columns.Count).Value = rng.Value Else
Hi Shoaib, The actual data gets written in this line... 'Put data into the Master worksheet trg.Cells(65536, 1).End(xlUp).Offset(1).Resize(rng.Rows.Count, rng.Columns.Count).Value = rng.Value
Hi Shoaib, Unfortunately, the Macro-Enabled part of the Workbook increases its file size. In addition, if you used too many formulae that also increases the file size. The only thing you can do is delete
Hi Shoaib, You can't count across all worksheets since a 3D formula such as "=SUM(Sheet1:Sheet10!A1)" does not work with COUNTIF. I'd suggest you to make a Master Counting worksheet, where you can enter
Hi Shoaib, Try these tutorial that can help you with merging. Note there are both VBA and Non-VBA (Google Data Consolidation) methods depending on your case. http://www.vbaexpress.com/kb/getarticle

©2012 About.com, a part of The New York Times Company. All rights reserved.