sep

Hi there, I hope someone can help. I have a spreadsheet where on worksheet 1: I document all events invoices in Excel. This includes the date the invoice is submitted for payment, the date the event takes place on, the cost centre it relates to, the P&L Ledger code, the supplier and the cost...

Hi All, I'm working with: Sheets("First SEP REPORT").Select Sheets("First SEP REPORT").Name = "Second SEP REPORT" Where I'm trying to select the worksheet then change its name. I have 24 tabs where this code is providing a sample of the macro I'm using above. Does anyone know...

Hi, I am working on input text file in to excel. I got code from Cpearson to this purpose '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ' ImportTextFile ' This imports a text file into Excel. '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Public Sub...

OK, this is a tricky one and I have NO idea where to begin to solve it but I'm fairly certain there is a way to do this. I have a workbook with two worksheets. One is named Expenses, the other Itemised Expenses. The Itemised Expenses worksheet has several columns but the salient ones are...

Hello, i am hoping someone can help with a few problems? I have dates spanning from 2014-2017 in Column A (A6:A400) and dates in Column B (B6:B400), I require a formula that will compare dates in A6 against B6 and so on to finally A400 against B400 where there are less than 90 days between...

<colgroup><col><col span="2"><col><col><col><col><col></colgroup><tbody> G/L - Expense Account Title GR No Invoice Date Name Period Class Amount 1001 Admission Fee 12 2-Aug-17 Alizay Ali ------ 2 25,000.00 1007 Computer Fee 12 2-Aug-17 Alizay Ali Aug/ Sep 2017 2...

Hi, On my Word form I have a field where I'm allowing the user to select the date using SEP Date control. Now whenever this document is opened the control displays Today's date. How can I set that to blank? I have tried by setting TodayString as " " but to no avail. Could some one help me...