notes

Dear Team, I want a calculation a cell where i put the no of notes received like if A1 Contains the Currency Detail and on B1 I write the qty of the NOTES received and on C1 the Calculation should Show A1 B1 C1 100 2 200.00 then if again i received 3 NOTES then I should Write like...

I have a large Excel document with several tabs. I am needing a formula that copies a specific cell to the new tab if the account information is listed. Sheet 1 (yesterdays report) Account number is in column B Account notes are in column EB Sheet 2 (todays report) Account number is in column...

Hi All I am looking to use a comand button on a excel sheet to search for a code within that sheet then do a vlookup in a folder to call up the required excel workbook. ok this is what i have, hope i explain it ok. Private Sub CommandButton1_Click() Dim CODE As String CODE = Range("N3").Text...

Hi, I am new to lotus notes automation using vba. I have a requirement wherein I have to loop through all the mails in the lotus notes DRAFTS folder and copy the filename of the attached file into an excel sheet. HELP!!! Thanks in Advance..

I am trying to add some more data and functionality to an existing database and having trouble figuring out how to pass the value that is being passed to main form also to the sub form. The reg# on main form is unbound. The reason the Reg# is passed as a variable I think is because that variable...

I am getting an error 1004 when calling refresh of a query within VBA. If I refresh the query manually, it works. The VBA code reads a table and determines the highest notes sequence currently used. It then reads a list of notes to add to the table and one by one, updates the insert query and...

Frustrating because I did this once before a while back but I cannot seem to do it again... I have a table [CustomerInfo] with customer info: Customer Number, Customer Name, Address, etc. There is no key as this is a linked table, but the Customer Numbers are unique I have a second table...

Hi. I created a worksheet (Actions) to track action items for a weekly call. Each call I use a new column with the date at the top (i.e. K10=1/1/2018, L10=1/8/2018, M10=1/15/2018) and enter notes for each item in the rows below it. I have created another worksheet (Dashboard) that gives a...

Hi all! Very happy to find this resource I will try to be as thorough/concise as I can be - I have a CSV file that we download for a number of customers. I have created a macro to remove all of the unnecessary information from that CSV file - Now, there is a field of audit notes that I am...

Hi can you help, I have two spreadsheets that i need to merge on a daily basis. Copy below. The number field is the unique reference. What I would like to do is find a formula that can look at the reference number in the master spreadsheet find the same reference number in the daily excel sheets...

Hi All, I`m looking trying to code my script for Excel, I have a Data set that looks like this <tbody> Country City Dollar Notes Hello Country City Dollar Country City Dollar Notes Hello </tbody> What I want to do is go through all my data. If I find something...

Hi, I am using Lotus Notes. =HYPERLINK("mailto:"&H119&"?cc=tradecorp@smbcgroup.com&subject=SMBC Deposit Rates "&TEXT(Today_TradeDate,"mm.dd.yyyy")&"&body=B117:F128","SEND") When I click on the above link, the hyperlink works perfectly. It opens the email in lotus notes and everything looks...

hi All, Need your expertise to assist me for below situation :- how can i extract the datetime (highlighted in red) in one cell? *** NOTES 01-Nov-2017 08:32:40 Axyz1 Action Type: Manager review *** Performed by contact: Anonymous Caller, (000)000-0000 Notes:SC- UPSELL...

I know how to write literal text, or the contents of a string variable into the notes section of a powerpoint slide. But how can I capture the text that's in an Excel textbox in order to do the same? If I record a macro when copying the text out of a textbox I get something like this...

I have two tables Customer and Notes Customer Table has: CustomerID, Customer Name Notes Table has: NoteID, Customer ID, Notes There is already a 1 to many relationship based on CustomerID I want to create a form that adds entries into the Notes table where the user can enter in the...

Hi, Been researching this for a while and can't find an example of how to set this up with Excel formula. I have two sets of categorical variable (ie yes/no answers) and I want to find the correlation between them Example: <tbody> Filled out notes field Did not fill out notes field...

Hi all, i'm having a problem trying to use my existing macro coding to work across multiple computers accessing the same files hosted on Dropbox. Currently I have created macros that will generate consecutive invoice numbers and then export the file as a PDF to a destination file with a prefix...

Hello, I am working on a project that relies on 2 workers individual reviews of the same movie. There is a concern that some of the second reviews are too similar to the first because the second worker is somehow copying the first workers review. I have about 14 thousand entries to audit and i...

Hi Team, I am new to VBA , Just started learning, if anyone has notes on vba, ya simple video to understand it. Please share. my mail id - mallesh_gangadhar54@yahoo.co.in Thanks a lot in advance !!! Regards, Mallesh

Hello, my workbook is set up to copy a sheet from another workbook into it. Someone will fill out a worksheet with their data, and someone else will use my program to work with the data. The form they fill in has a few spaces for "additional notes", ie, essentially any information that doesn't...