Forum Widgets
Latest Discussions
Baud rate of 460800 in excel data streamer
Hi, I am trying to acquire data from RPLIDAR C1 in excel data streamer, but the baud rate to make it work needs to be 460800. When I try to change it in excel data streamer it does not offer that speed and when i type it it does not seem to keep it. It's back to 9600 as soon as i close the advanced window. any suggestion?
Conditional Formatting for multiple range
I wonder can we make conditional formatting in excel to hightlight certain values in multiple ranges in a couple of certain columns? so for example all 3 tables in a worksheet, all tables had different row lengths and i want to hightlight automatically 3 largest percentages values in range between "Percentage of Total" and "100,00%" which is the sum of percentages in each tables. Is there a way to do that?
网赌被黑怎么办 有办法挽救吗？
（wx:RYG622）（QQ：157764444）（飞机@lmg567）先出款，后收费! I have a macro that I've written to "reformat" some data in Excel (not font types and colors and such, but how the data is laid out in the spreadsheet). I found a macro that records how long it takes a macro to run, and that macro consistently runs for about 30 seconds. The problem is that the reason I'm reformatting the data is to import into Access, and I don't want my users to have to have intimate knowledge of Access or Excel to reformat the data and import it into the Access database. Thus, I've created a form with a button that allows the user to select a file from a dialog box, and then the macro runs on that file. Ad for some reason, when done this way, the macro takes upwards of 6 minutes. I don't know if it would be helpful to post the code of the macro here, or if there's some generic advice that will help. I just can't imagine why this increase in run-time is happening.
Regional CSV Issue
Hi I was wondering if someone could help with a very annoying CSV file issue. I am a remote worker based in South Africa working in a finance team for a UK based company. The company uses Xero as their accounting software, and to import data into xero I need to create CSV columns with data in multiple defined columns (which vary depending on what type of data I am importing) However, for some reason whenever I download the CSV template direct from xero, populate the columns with the data and save it, when it comes to importing into Xero, I get an error message saying Xero can’t read any of the data. I have sent this CSV file to my manager, and when he opens it, the column headers in row 1 are all in the right columns, however the data that I have populated in rows 2 and below are all bunched together in column A, with lots of commas separating the different data points. Likewise, if my manager creates the CSV himself, and then sends me that file, when I open it the same thing happens again (Column headers in row 1 stay in their columns but all data from row 2 and below gets bunched up together in column A) I am pretty sure it is a delimiter issue, but I have tried changing my regional settings to no avail, as well as using the text to columns button and using comma as a delimiter then resaving, but that still doesn’t work. Any advice would be greatly appreciated
Move up to next blank row after copy/paste from previous sheet.
Snowman got me rolling with code that does almost exactly what Im trying to do. After I hit end of day button Im trying to get the copied data to move up to the next blank cell in column B within a range. If I have any data in B2:B9,B11:B21,B23:B29 marked with a t next to it in column A and hit the end of day button only data in cells marked with that t are moved to the next sheet in the same cells they came from. What Ive noticed is only data in B2:B9 go to the exact same cell. B11:B21 are offset by 1, and B23:B29 are offset by 2. This is fine as the data is still moving. What I want it to do is for those ranges move up to the next blank cell in column B. So if I have data only in B4, and B6 I want that to transfer to next sheet in B2,B3. The same for the other 2 ranges. I also dont want it to overwrite anything that may already be in a cell on the next sheet. If I have "Tree" in B2 of the next sheet I want the data to go to B3,B4. Same for the other two ranges. I have tried xlUp, xlDn, and played with the code that was given to me by Snowman to try and make it work. Im not getting anywhere with this. I thought maybe if I create another macro that after I transfer the data would move everything up into blank cells then Id be okay with that also. Im not having any luck with that either. I even recorded a macro for copy/paste but that wont work if there is data in a cell already that I need to keep, and not be overwritten. I have attached a copy of the workbook. Hopefully this time it will allow it to be published with this query.
"Reverse FV" function? Or?
Hi all, I need some help please. I would like formula for excel, where I have known inputs: A1 = 30 (number of years) A2 = 500000 (needed capital) A3 = 8% (known yearly return of investment p.a.) A4 = 10000 (initial investment) and I need to calculate needed monthly investment, to reach that required sum (in A2). Thank you very much for your help and time. Daniel
Excel
Português (BR): Estou enfrentando um problema persistente na padronização de dimensões de ilustrações, imagens e pictogramas no Excel. Mesmo ao tentar definir uma altura padrão (ex: '1.4' cm para uma ilustração de hexágono) no campo 'Altura' da guia 'Formato da Forma', duas figuras diferentes, com ambas selecionadas (Segurando Ctrl), resultam com tamanhos divergentes (ex: 1,38 cm e 1,36 cm), em vez do valor exato digitado (1,4 cm). Já verifiquei as propriedades, incluindo a fixação da taxa de proporção, e tentei soluções como copiar/colar e reiniciar o Excel, sem sucesso. O mais intrigante é que, por um breve período, consegui padronizar as dimensões corretamente, mas o problema retornou inexplicavelmente, mesmo no mesmo arquivo. Suspeito de alguma configuração ou atalho que possa estar interferindo. Percebi que isso não acontece, por exemplo, no PowerPoint, apenas no excel. Gostaria de saber se possuí algum tipo de configuração específica para não ocorrer esse ajuste/arredondamento automático no Excel. E gostaria de uma solução eficaz para garantir que todas as ilustrações selecionadas mantenham o tamanho exato que digito.
Excel no longer opening files with [] in the file name
Since office 365 upgraded to version 2504 our users have been unable to open files with [ ] in the file name. Example a file with the name [12004][]_MCH_12004-SSC Pacific.xlsx excel throws the errors Basically cutting off the whole file and only finding 12004 now. Why was this functionality taken away. We understand that [] is not recommended in an excel file name. We have antiquated systems written in COBAL that auto generate these file with the brackets. Older versions of office still can access the files but anyone with 365 can not. How can we get this functionality back? Nothing in the changelogs for office version 2504 mentions a change to remove this functionality.
