note

Howdy y'all, I'm currently working on a sheet where the user has requested a macro that will attach the image of an invoice to the note of a cell so they can hover over the cell to see the image of the invoice. I've got VBA code to make it all work (sorta) but the issue is that they will...

I am working on the following workbook Notes.xlsx but can't seem to get working. What I need the program to do is: Take two sentences or paragraphs and make them into one I need the paragraphs and sentences to be punctuated correctly There can't be any spaces between the paragraphs If a...

Hello, In Networkdays formula, we have "holidays" part, where we can easily use excel list of holidays that we created in advance. But what I want to do is to note holidays in the formula manually (not from existing list). For this reason I write holidays in the Networkdays formula with the...

Dear Experts I want a table in which the No of Currency received/given to be record in a cell like for 1000 Note 1000 4 500 200 100 . . if i receive 1 note of 1000 rupee then i write 1 in front of 1000 rupee cell if i receive another 1000 rupee note then i write 2 in front of 1000 rupee...

All hi, Kindly require to provide me a support so that a VBA code to run through col. “C” and where the first 8 digits and less from left side are common, should place by alphabetical method a letter and space on left. Note that the first common number/reference should remain unaffected and...

I'm working on implementing VBA code that adds a comment column right after a pivot table. The link below on post #108 is the code I'm using, but my question is what part of the code do I modify to have the comment column(s) be 4 columns after my pivot table instead of the column immediately...

I have a large excel workbook that was made with excel 2003. I am now using Excel 2016. If I "convert" the old worbook to the new 2016 format, is there any downside? (It seems to work fine, but will it work as well with no lags, or issues, when compared to if I made a "new" workbook with...

Hello, I need to input equations into solver in Excel (Its easy to do most of these outside but the automation is helpful) For example $120=$93.50*X+(S:S)*($3000-X) How would I type this equation into Excel to have it solved. NOTE: In this case S will be from a list of Values.

I have a cell that contains a count down to a specific time. The count down appears like this: 10d 23:18:43 Is it possible to write a formula that will convert the count down to hh:mm:ss? In the above i would expect: 263:18:43 Note that if a single day is left the cell looks as such: 1d...

Cross-post ! So here is macro: Private Sub NoteZoom3() With ActiveWindow.VisibleRange NoteChangeSize .Width, .Height, True End With End Sub Private Sub NoteChangeSize(w!, h!, Optional scr As Boolean) With ActiveCell.Comment.Shape .Width = w: .Height = h...

Cross-post is here! I have «Microsoft Office 365 2019». First of all i want to tell how <code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco...

Hello, I never had this happen before, can't figure out what I am doing wrong. I have a excel sheet that looks like this...(note the blank columns) But when I paste into an email, it looks like this...(note the spaces are no longer separated) DateTypeDebit"CheckNumber"...

I have the following which seems to reset comment/note boxes only when the red indicator is hovered over: Sub ResetComments() Dim cmt As Comment For Each cmt In ActiveSheet.Comments cmt.Shape.Top = cmt.Parent.Top + 5 cmt.Shape.Left = _ cmt.Parent.Offset(0, 1).Left + 5 Next End Sub However...

Hi Guys, I'm hoping you can help me.... I'm trying to create a simple spreadsheet in excel to keep track of my daily conversations. I have the spreadsheet laid out horizontally which I guess is not ideal (I can transpose this if it makes life easier). I'm hoping to put the date in each week and...

Hi all, I have a situation, wherein i need to separate the below numbers and will be input to other info. 1.5 X 3 X 8 3 X 1.5 X 10 I need to get first numbers-1.5 3 I need to get Mid numbers- 3 1.5 and note there...

Hi, I would like to ask a macro where it will search through a folder and subfolder and put the result in columns in excel. Sample is : words to look in a note file - 'Note', 'black", 'white', 'blue' if 2 words found: column1 column 2 C:\document\txt1...

Hi All, Please note that, i want to get outlook current date (today) email subject name, Email received date and time in a excel. Note : I have configured business Queue in my outlook. I want to get the data from added business queue. Any one can help Regards, Mohideen Thasthahir

Hello Guru(s), In previous version of Excel, you could edit the format of a note to show a picture by changing some settings in the format/fill tab. This latest Jan 31st 2019 release seems to have removed this nice little feature. Any idea how to do this now? Basically any way for a picture...

Hi, Just looking to see if there is a method to sum values in a range between recurring words in a separate column. I am trying to use one column for the formula in the total column. So far "=IFERROR(IF($B4*$C4=0,0,$B4*$C4),0)" is in column D with some conditional formatting. I would like to...

So MS has renamed the old Comments to Notes, and the new Comments have become threaded conversations. We're now using Notes in the same manner as we used to use Comments. The problem is, EDIT NOTE nor NEW NOTE appear in the right-click menu when in a cell that has a Note, only DELETE NOTE. Is...