data manipulation

Hi I need to transpose some data for which a normal transpose doesn't seem to work. The file is available at https://docs.google.com/file/d/0BzsDpPI91t9FMTNRRjQyOFF0N0U/edit?usp=sharing What I want is to transpose this data so that column F becomes a list of the month (as mentioned in row...

Hello, I am pretty new to Excel Macros. I've been searching the net and found this forum to be VERY helpful; not quite able to find exactly what I need. My question refers to vehicle fitment for auto parts I have compiled, however need to manipulate the data further. Example (fitment data...

Hey there, I'm a student working on some economics research (thus the username) I'm new here and I've been looking through the forums as of late finding some really helpful stuff, but now I'm stuck with the following predicament: I have an excel spreadsheet with all the airplane routes that...

Hi Guys, I have just started a university society and am in charge of most of the admin. As part of this I need to keep track of members details. Currently we have an entry form set up via Weebly(a website building platform) which allows us new members to enter their details and subsequently...

Hi, I have developed a workbook for estimating project costs based on selected Labour, Material, and Plant components, but I've recently dicovered classes and collections and was wondering whether they could be used to develop a more efficient solution. The data is multi-dimensional, i.e...

Hi I am using excel 2007 and i am having problem on what formula to use on my third sheet... my first sheet is my Main Sheet where I input data and a button for encoding. Excel WorkbookABCDEF12poducts34date delivered5monthDateYear6location of delivery78delivered by910sales1112Encode13Main...

Hi I am using excel 2007 and i am having problem on what formula to use on my third sheet... my first sheet is my Main Sheet where I input data then, a button for encoding. Excel WorkbookABCDEF1******2*poducts**3******4*date delivered****5**monthDateYear*6*location of...

Hi I am using Excel 2007 and I am having a problem on what formula to use on my scenario... this the scenario i have 3 Sheets, first sheet is my input sheet Excel WorkbookABCDEF1******2*poducts**3******4*date delivered****5**monthDateYear*6*location of delivery**7******8*delivered...