chips

Hi, I want to set up a simple vlu loop to copy data from one sheet to another and I want the loop to end when when the loop reaches the end of the list. let's assume the list of items with prices (columns 1&2) is on sheet 1 and the vlu required (column 3) is on sheet 2 Its early days for me...

Hello! Ok; I've never created a macro before and would really appreciate some help. I am trying to create a spreadsheet that will populate data based on a few criteria so that I do not have to constantly type everything out each and every time. On one tab, I want to have a start date and an end...

<colgroup><col width="101" style="width:76pt"><col width="82" style="width:62pt"><col width="81" style="width:61pt"><col width="74" style="width:56pt"><col width="90" style="width:68pt"></colgroup><tbody> Good morning Mr Excel, would like to ask how to code the minimization VBA code. The...

If you have ever done any serious VBA programming in Excel, then it's almost a lock that at some point you found yourself at an impasse, did a search and found yourself visiting www.cpearson.com where you found a well-documented and well-explained solution to the problem that had been vexing...

Hi, I have been trying a formula to return row and column heading from table 1 including the cell value of the cell with value in it. I had been trying to follow this post ...