note

I need a tooltip on column 3 and 4 and show the related value of sublistitems(11) Possible? Note: i'm on Excel vba

Hello all, I could use some help here. I need a code that can allow the cell to autocreate a note where the name of the user who enteres data will be automatically filled in. Is there any way to accomplish?? Thanks in advance.

Hi, We have recently purchased a barcode scanner to scan all of the products that get delivered to us and what we want to do is check against the delivery note to see if we have received everything on the sheet. What I am looking at is something along the lines of: We have a tab with an...

Dear Sir, i want to say that i have a sheet where i need to calculate the no of NOTE(Currency) received the whole day, currently what i do is all the time i have to calculate the received amount with the amount entered in the cell. what i need is i only enter the no of note on the cell and...

Hi, i was kindly provided a formula as a solution to a problem though, it didn't work 100%. I believe the issue is due to the formula using a rounded number and would like to know of a solution if possible? The formula is =INDEX(J1:AC1,MATCH(D8,INDEX(J2:AC7,MATCH(F4,I2:I7,0),0),-1)) F4 in...

Hey guys, I have a couple of URLs that contain the "origin?" text before the part I want to extract. For example: wwwXXXX.com/ie-de/origin=10_se_Display_native wwwXXXX.com/ia-de/de/origin=10_se_Display_on wwwXXXX.com/ia-it/de/origin=10_se_Display_off I want to create a new column containing...

Hello all! I have an event that require card access to validate attendance. Note: The card scanner populates cell B2 and overwrites the same cell after every scan. <tbody> A B C D E F 1 ID SCANNER SCANNED ID NAME 2 9000 8000 BURNO 3 Y 9000 JAMES 4 5000 ADAM </tbody> When...

Hello I had a recovered Excel folder which disappeared after opening and closing a file within it... Why? How does excel manage its recovered files? See attached on cross-post. Note : The folder was named something like : "Pension%20Analysis%20CAD[...]Jan18[...]". Cross-post...

I have a macro that imports data from an outside workbook to the active workbook. A problem I am having is that some of the numbers have leading zeroes, then they do not come over. Example: if the number is 099999999, it shows up on the new sheet as 99999999. Any ideas how I can get the...

Hello Guys, I have my sales report in a table starts from column I7 to M7. In I column i have my product name, in J column order status and in M column quantity of the product. My requirement is IF cell content in J column reads ordered and M column cell content reads quantity as 5, then the...

I have a big long list of raw data in a table (2500 rows and 10 columns) that I need to be able to do the following with... Search for data in column A, then present the data on the associated row, might be multiples allow a user to save a note with that row of data and assign a date and...

Hi. I am trying to develop a formula to add a comma after every: "=1" or "<>1" example: if(AND(KO9=1MA9=1XJ9=1RG10=1RW10=1ZR10=1LG11<>1ZR11=1),11,"") note: the number of characters before the "=1", or "<>1" may change, ie KO9 to AFD13

Is there a function or command that will attach a completed worksheet as a file in an e-mail note when a hyperlink is on the worksheet with the mailto:anyone@hotmailcom filled in as the hyperlink? I'm trying to have a user complete a worksheet, click on the embedded hyperlink that opens an...

I work in the banking industry and I am trying to save some time. I work fraud debit card claims and when we deny a claim, we have to use a lengthy note to leave on the claim. As of right now I have one that I can copy and paste but I still have to take a min or so editing it. So I created an...

Team, I have a table with columns... Opened - date a ticket was opened - format = dd/mm/yyyy Group - name of a group ticket was assigned to - format = [text string] Active - flags whether the ticket status is still open - format = true/false I currently have a pivot table set up, where...

Just need a simple macro to convert a whole column R data to decimal Example 945 920 So the output should look like this 9, 2, 0 and 9, 4, 5 .Please note there is one space after the decimal. Thank you for any help

hello please help me about same words in column B. i have dic data and meanings are in Column B. but some rows are same. so i need to add queue number to end of word to be different from eachother. example: A B Book note lesson note teach make learn desk note...

Need some expert help, please. As you can see below, the formula in cell c13 is an array that calculates a 12-day moving average for that data in column B. You can also see that column B has non-numeric data, which is why I'm using the array in C. Here's my problem. I want the formula in...