Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #16  
Old 04-15-2011, 03:21 PM
macropod's Avatar
macropod macropod is online now HLOOKUP, if,? OR MACRO Windows 7 32bit HLOOKUP, if,? OR MACRO Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,481
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Bobby,



Try the attached update. The main issues were that the code was:
• starting from row 3 on the 'Welder Totals' sheet instead of row 2; and
• testing column B on each worksheet to get the count of used rows. On some sheets, that column was either empty or incomplete. It now tests column A.
Attached Files
File Type: xlsm Weld ProgressionPOSTONLINE2.xlsm (307.2 KB, 17 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
counta, countif, hlookup



Similar Threads
Thread Thread Starter Forum Replies Last Post
HLOOKUP, if,? OR MACRO Help with a macro Takket Word VBA 2 03-28-2014 04:58 PM
need a macro that does the following atomsk Word VBA 0 07-05-2010 07:29 AM
Please help Jarrod Word 1 06-05-2010 06:31 AM
I need a macro, who can help me? Bahir Barak Word VBA 1 05-26-2010 12:24 AM
Macro help NEHicks503 Excel 0 04-16-2010 07:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft