help needed!

Hello people, I need your guidance.:)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am running reports from a system daily that gives me the information in a CSV. I then have to do loads of formatting to make it look presentable but have found the glory...

I need to have the page number automatically entered into specific cells in my sheet. a header or footer wont work here. i have 170 page in the sheet wich on them have different items. each of these item codes get recorded on a different sheet including wich page it is on . for reference and...

Trying to write a code that will accomplish the following: 1. If cell "H16" is "Yes" then unlock range E47:E53 2. If cell "H16" is "No" then fill range E47:E53 with zero's and lock. Given-working on Sheet5, and let me know if the range E47:E53 needs to be normally locked or unlocked. Also...

Trying to write a code that will accomplish the following: 1. If cell "H16" is "Yes" then unlock range E47:E53 2. If cell "H16" is "No" then fill range E47:E53 with zero's and lock. Given-working on Sheet5, and let me know if the range E47:E53 needs to be normally locked or unlocked. Also...

caN somebody help me

So, I use to be a lot better with Excel, but it's been quite some time, and I'm in Dire need of help. Here's the issue: I have a spreadsheet with 12,000 contacts in it (name, email, phone number, country, industry, etc etc). The sheet is kind of messy, and I want to clean it up. One way thing...

I am trying to create a list of permutations in a column for example I need a list of numbers 1-20 with no numbers repeating. This is causing my head to hurt and I have been working on this problem for some time. So any help would be much appreciated and is much needed.

Hi I'm wondering if it is possible for someone to do me something up as I'm no coder. What I'm essentially wanting to do is be able to search through a list of words within excel and filter out anything that is not in the standard English dictionary and also remove numbers; these words will have...

Hey Excel Ninjas... I have been a silent worshipper of this site for a while but now I have to ask something... I have an issue with a lot of text that can only be dumped by the sytem into one column. The only problem is that it needs to be parsed and sorted by a bunch of different things. I...

I am having problems with excel taking one column of time away from another, lets call them A and B (each row is taken from the same occasion). I want to find the difference between A and B (either of which might be the later time) and I want that given in time as either a positive or negative...