comments

HI OK so I have a formula that pulls in cell contents from 2 spreadsheets into a 3rd spreadsheet based on date input. =IFERROR(LEFT(INDEX(Sheet1!$B$3:$M$20,MATCH($A17,Sheet1!$A$3:$A$20,0),MATCH(B$4,Sheet1!$B$2:$M$2,0)),1),"") So for any date input it will display the cell contents for that...

Hi All, Hoping you could help with my current problem I have with Power Query. I have a raw data file which is updated monthly. I use Power Query to split this raw data file into a number of workbooks based on the centre code as different members are responsible for their own centre codes...

I use the following code to implement a stopwatch: Dim NextTick As Date Dim t As Date Dim PreviousTimerValue As Date Sub StartTime() PreviousTimerValue = Sheets("timer_test").Range("O2").Value t = Time Call ExcelStopWatch End Sub Sub ExcelStopWatch()...

Hi all! New to the forum, and I have a question about creating a macro. We have techs in the field collecting data about timber. Each day, we export that data to spreadsheets (images of the relevant sheets below). The way the recorders work, a certain field (Plot) has data (comments)...

I'm currently working on a spreadsheet and have encountered a problem. I've got a master raw data spreadsheet, and have set up another workbook with a data table, pulling filtered data from the raw data workbook (filtered to only show open cases). I have then set up a series of vlookups...

Hi there, I am trying to create a formula that scans a column and, if there is any data in that column, list the data on another sheet. For instance, one sheet is called data and the data sheet has the column 'comments'. The Comments column has some rows that are blank and some that have text...

<tbody> comments serial no. model no. part no date serial :1235468 model: III-5400 part :tab3gd1 D:05/08/2018 56788 III-555 gac56r1 05/08/2018 </tbody> Hi All, Please I need help in this matter. I have over than 300 rows. and I have a column of comments with data in each...

Hello Everyone, I work as part of a hotel & am trying to work on a report. Please can someone help me find an answer. I have a table with Column C where employees assigned this task put in comments on a daily basis. I review this report & make changes if any before the report is shared to mt...

Hello Everyone, I was trying to prepare a Report of a Hotel business I work under. I have a report that tracks the records of each division & the focus is very high on the comments provided. Attached Excel file has an example of how the report looks. Column "C" has comments that is populated...

Hi, Is there any way I can highlight (fill color) cells with color, but then when I print/export to pdf, those cells will be printed as non-fill cell (just like normal)? It's like "insert comments" but not printing those comments in printout. Thanks.

Hello, I had gotten help on this in the past, but I am working on another project that is similar but I am having a hard time adapting the code to work. First, here is the code I have as of now. Sub HighlightIfNotTwoDecimalPoints() Dim R As Long, c As Long, X As Long, StartRow As Long...

I have a workbook where i am comparing two worksheets that should be identical for the most part, including comments. When there is a difference, I am marking the cell yellow in the main sheet and then creating a formatted comment with details on what is different. As many of the cells have...

SUMMARY: I've got a sheet of data that I need to have exported to Word via a mail merge, and this specific task happens regularly enough that I want to automate it, especially for other, not particularly tech-savvy, people who have to do this from time to time when I'm not available. Is there...

Hi all, how to know which cells have comments in a sheet? (ActiveSheet) thanks...

Is there anyway I can paste a table into the cell comments. Everything I try doesn't work.(ctrl+c and ctrl+v) right click and copy and then right click paste. all I'm trying to do is insert something like this into a cell's comments. <tbody> 100 50 20 $ 100.00 10 5 2 1...

Hello, I am still struggling with my VBA skills and trying to figure out how to do this. I can picture in my head what I need to do, but nothing is working for me with VBA. Here is my raw data, or a sample of data...

Hi, I have a file which used to work fine but now has a problem - the only difference is that I have upgraded from Excel 2010 to 2016 (which I guess must be the issue!?). A wksht has some cells that have comments in them. The sheet is password protected to prevent the user 'breaking' anything. I...

Hello, I have a file I update it every week and send it to my managers and colleagues.Recently I get a message of protected view, andI have to choose "Enable Editing" to do my data entry. It always happens when I get a “save as” or renamemy file. My problem is with inserted comments. I hide my...

Hi, So I am wanting to help make some of our team's work a little easier but have no idea how to go about it. We have this spreadsheet that is filled in with information needed by various teams to create accounts. These teams fill in the information manually from a ticket that gets...

Hi all, I have a client comments in sheet Client Comments that I would like to paste to sheet All Comments. Client ID's are in Column AV and comments in Column CE in both sheets. The code below takes 13 minutes and doesn't paste any comments so would appreciate any support. In Phase 1, I'm...