help!!

Hi, I'm new to all this VBA coding so forgive me because I know this question has been around in various guises before but I cant find the code to do exactly what I need to do. Here goes... I have a workbook with the worksheets named Complaint Chart, Pivot Table, Pivot Charts. I run a user...

So.. I was happily working on my macro enabled workbook in excel 2010 and I decided to finish working on the document so went to close the workbook. It asked me If I wanted to save the file, I clicked yes, it gave me an error saying that I am using a reserved word for one of my Sub's within the...

Hi, long time reader first time poster! Any help would be greatly received as i've taken to banging my head against the wall! I have a large worksheet that I need to extract data (rows) from based on the date and certain criteria within that date and row. My VBA skills are limited so if this...

Hey, I'm really stumped on how to get a formula correct in Excel please have a crack at this: A product costs £10. Each product has 14 units in it. So with each unit costing 0.7 I need to be able to get a formula that gives me an 80% return on each unit. :warning:Does that make sense?

I am facing kind of a unique problem i made a work book that is supposed to calculate packaging requirements for a production plant the macros on it was working fine until one day it started to stop working over an " over flow Error " due to failure in referencing cells with the required...

Hi all, I am trying to get a table that is created based on the numbers i have. eg i have the following data in cells A1:B4 1 List 1 1.00% 2 List 2 2.00% 3 List 3 3.00% 4 List 4 4.00% Ineed a formula that will look at them and put them in highest order first in cells...