Thread: [Solved] HLOOKUP, if,? OR MACRO
View Single Post
 
Old 04-14-2011, 07:02 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,340
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,

Your latest workbook doesn't seem to have any welder ID data on the various worksheets from which to compile the stats. Also, I need clarification of one issue:
• You say "I would like to put the number xrayed between columns, B-C, D-E, ect." You can't put anything between columns - data must go in columns. I assume these new data are to go onto your 'WelderTotals' worksheet. If they're not going into the existing Columns C, E, G, etc 9which look like their meant for the simple counts of welds, then you're going to need new columns for the new data. These could be inserted before/after each of the existing columns, or as a group somewhere after Column P (the existing Column P could be moved to suit)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote