creating

Can someone please help with providing a formula which generates a list of text values in multiple columns which satisfy a certain criteria (i.e. a '1' in the row) and ignores the blank cells. Example below: <tbody> NAME1 NAME2 NAME3 NAME4 NAME5 NAME6 NAME7 NAME8 NAME9 NAME10 1 1 1 1...

Hi Guys, i need help in creating an ini file for GPS co-ordinates ($GPRMC format). Currently in excel i have latitude and longitude below is the attachement: ---- excel file but need to create an .ini file in the format below: [GPS Coords]...

Hey everyone. I’m looking for help in creating a unique chart in excel. We are currently using PowerPoint to creat this chart and I want to simplify with excel. The best example I can find it the link below on Google. It is called a Project Status Spectrum chart. The chart is great for what I...

Hello Everyone, I know this question has been asked before, but I have not been able to find a satisfactory solution. When creating a PDF from Excel, hyperlinks appear to be active only when the destination URL itself is the link text, or when using Excels "insert link" function. Unfortunately...

Is it possible to convert an application from Access 2003 to Access 2007 not creating an .accdb? tia Jack

Hello all, I am not new to Excel. However, I have trouble creating V Lookup's. What is the best way to go about learning to creating a V Lookup? Ebony

Hello, I have been tasked with creating an upload for a business we work with. The file has to be in exact format. I have very little experience working with txt files. I've created the data in Excel pulled from a variety of data sources. The worksheet is then saved as a txt file. I've...

I have situation where we have an ongoing survey where the survey file needs to be merged with a master member table to bring over certain fields (age, gender, ethnicity, political affiliation) in the survey table for analysis. I tried to create a one to many relationship in Access and PQ but...

Hi I have 1 workbook with 2 sheets. Sheet 1 contains an invoice template and sheet 2 contains rows of customer details from columns A to O. These are your standard CustID, first name, last name, balance etc. For each row in sheet 2, I want to copy over the values to specific locations in the...

Hello, I have been struggling to find anything on creating a calendar on a basic form where you can click on the day and schedule an appointment. I would like to have the user be able to view the month, choose a day, double click the day they want, a form opens for additional info relating to...

Hi all I've been googling for 2 days on this and still have nothing. I'm looking for some VBA code to seek out and remove all / any .TMP files that are created, across a whole server. I'm looking cause we have a issue with in my business of files creating lots of .tmp files If anyone has any...

Hello, I am using microsoft office excel 2013. I have googled everything I can think of and all I can find are ways to create barcodes from numbers I type in. I am trying to see if it is possible to generate barcodes with random numbers so that it will not create duplicate barcodes. Maybe if it...

Hi I'm sure this can be done but I cannot for the life of me work it out. In a nutshell I want to copy (create) multiple workbooks and name them based on the list of filenames in Sheet1. I have a sheet with a list of file names in column A e.g:- A - 2011.xls B - 2011.xls C - 2011.xls...

This is a first time I have registered for any of the forums online. I have been working with Excel for quite sometime but only with the Formulae & Formatting and very little with Macros. I have achieved all my goals with the above, but this task has been a bit confusing for me and has confused...

1. I want to create 365 sheets consecutively starting from 01JAN11 to 31DEC11 2. After creating 365 sheets, based on above sheet name format I want to insert date in a row in respective sheet as [$-409]dddd,mm,dd,yyyy (for ex. Saturday, January 01, 2011). Can anyone guide?

Hi people, I have just recently managed to create a quiet sensible football league table where the table gets generated automatically by entering the results of the matches between the teams. What I need is whether it is possible to sort the table automatically after filling in some results of...