Flux rss
Search : in
By : Relevance Date Username
Statut : Not resolved

Excel data extraction macro needed

Theo, on Monday 15 September 2008 à 09:14:55
Hello,
Hie .I am working on a project in which l have to compare dates in excel and enter the difference (in days)in time in a separate column .l am looking for a macro which can extract data from text ie if the end date of a task in a project is say 2008/08/10 i n a previous project review then it becomes say 2008/10/12 .l need to write a macro which can tell me the difference in figures ie it subtracts the earlier date value from the latest one to give me the time difference in days.Is it possible? Is there anyone who can assist?

Thanx

Theo
Configuration: Windows XP
Internet Explorer 6.0
Reply to Theo  Report this message to moderators Go to last message

1


  • This message seems useful, vote!
  • Report this message to moderators
andy6776, on Monday 15 September 2008 à 11:49:57
hey there,

just try to see the help about macros on the forum itself you might find what you are in search of
   
Reply to andy6776

2


  • This message seems useful, vote!
  • Report this message to moderators
 Mohinder, on Friday 7 November 2008 à 17:57:54
HI Andy, thank you for the Message. I will definitely try this out
   
Reply to Mohinder
Ask your question Reply

Résultats pour excel data extraction macro needed

Instal XP (Solved) Bonjour, Bonjour, J'ai un portable HP Compaq 6720 S qui tourne sous Vista; j'ai voulu remplacer Vista par XP: Format du disque Sata puis install XP et au début de l'install il me dit qu'il n'y a pas de disque. J'ai... en.kioskea.net/forum/affich-6855262-instal-xp
Bring Rows of excel that have been changed Hello, Dear All , i need your help I have a huge excel database and i need to create a macro which will identify the rows that have been changed for a period of time and bring them in a new spreadsheet. In other words, to use audit trail and then by... en.kioskea.net/forum/affich-30569-bring-rows-of-excel-that-have-been-changed
Lost data after saving Powerpoint presentatio Hello, We use VBA to generate Powerpoint presentation using data from Excel. Data inserted into charts datasheet disappears after we save it. We stepped through the code to determine that after the file is saved, we cannot access the data from the... en.kioskea.net/forum/affich-28802-lost-data-after-saving-powerpoint-presentatio

Résultats pour excel data extraction macro needed

InDesign/Quark XPress/Publisher - AlternativesScribus Freware Pageplus SE InDesign/Quark XPress/Publisher - Alternatives Microsoft project is a software for formating and printing project plan usually used by project managers for business and managing budgets. Comparatively to... en.kioskea.net/faq/sujet-303-indesign-quark-xpress-publisher-alternatives
1 2 3 Next

Résultats pour excel data extraction macro needed

Excel active cell macroHello, I'm trying to write a macro in excel which would copy and paste a range from WITHIN THE SAME ROW in the same sheet as the active cell is selected. For example let's say i select a cell within range A6:P36 then i would like the macro... en.kioskea.net/forum/affich-25813-excel-active-cell-macro
Transfer data between sheets in excelHello, This involves an attendance sheet. A tab for each month with columns for weekly attedance and a total for the month and a summary tab containing the students names and the monthly totals. I would like to transfer students' names and the... en.kioskea.net/forum/affich-26615-transfer-data-between-sheets-in-excel
Pretty Basic Excel Macro HelpHello, I am writing a macro (which will be used to create a VB6 program) in Excel 2003. The spreadsheet Update_Log is a database with 9 user input columns and 7 columns which are calculated by formulas based on user input. I need to create a macro... en.kioskea.net/forum/affich-15106-pretty-basic-excel-macro-help
1 2 3 Next

Résultats pour excel data extraction macro needed

Download Excel ViewerWith Excel Viewer, you can open, view, and print Excel workbooks, even if you don't have Excel installed. You can also copy data from Excel Viewer to another program. en.kioskea.net/telecharger/telecharger-52-excel-viewer
1 2 3 Next

Résultats pour excel data extraction macro needed

E-Business - Data warehouse and datamart The different data for the intelligence information system are stored intermediately in a place called data warehouse. The data warehouse is therefore the only place where all enterprise data are consolidated. The creator of the Data Warehouse... en.kioskea.net/entreprise/datawarehouse-datamart.php3
1 2 3 Next