Search Box Macro Script To Search Using Filters In Sheet
Hi there, There are ways to create a search box in excel using a VBA. The main macro code is pasted below. I was wondering if this could be doable with Zoho sheet. Would this code work? Or, do you guys have a solution to search the sheet and filter the results? Thanks, Chad Sub SearchBox() 'PURPOSE: Filter Data on User-Determined Column & Text/Numerical value 'SOURCE: www.TheSpreadsheetGuru.com Dim myButton As OptionButton Dim SearchString As String Dim ButtonName As String Dim sht As Worksheet Dim
zoho sheet, hide column function added in new version. But what about hide column function in VBA?
Hi guys, I really like the hide column function in the new version, but can i use it also in VBA? Because that would be great, so hopefully you can give me some code to work with or create it :-). Already thanks. Wilco,
Zoho Sheet, button with macro don't work anymore in the new version?
Hi guys, I switched over to the new version of zoho sheet, but now my button with macro don't work anymore. When i switch back to the old version it works again? This is an example of what for code i am using. Sub Docenten() ' ' Docenten Macro ' Gemaakt door wilco02 op maandag 22 oktober 2018 14:18:08 ' Range("F1:K65536").Select Selection.EntireColumn.ColumnWidth = 0 Range("X1:BE65536").Select Selection.EntireColumn.ColumnWidth = 0 Range("A1").Select End Sub The code
Zoho sheet, data validation limited in new version zoho sheet?
Hi guys, I made a search box with data validation for about 600 customers. It works perfectly in the old version, when i switch to the new version it seems to be limited and shows only about 100 people? Do you guys also have this problem? And how can i fix it? Already thanks./
Zoho Sheet - Split cell diagonally fill half color
is it possible to split a cell diagonally, fill different text in each half and ideally color them differently as well?
Document is weak
Hi. I want to work only sheet api my problem; I can't get TOKEN... Step 1: req https://accounts.zoho.com/oauth/v2/auth ?response_type=code &client_id=1000.P4Z0WWOLFDGRT23126TYD3B4JWQ5TE &scope=ZohoSheet.dataAPI.UPDATE,ZohoSheet.dataAPI.READ &redirect_uri=http://mydomain.com/zoho_result.php &state=-5466400890088961855 res http://mydomain.com/zoho_return.php?state=-5466400890088961855&code=1000.041b7b5928bbab9f0af9fdce95126e73.1fac756c41995bd37728b2ec5c1f2d1d&location=us&accounts-server=https%3A%2F%2Faccounts.zoho.com&
Bypass the url by a local url
Hey everyone, i'm using the Excel preview api and i wanna know if is it possible to change the url who is the excel file stored in a server by a local file who is stored on my computer ?? This is the Api link : https://sheet.zoho.com/sheet/view.do?url=http://link.to/file.xls&name=newName And i want something like this : https://sheet.zoho.com/sheet/view.do?url=file:///C:/Users/PC/Downloads/myfile.xls&name=newName Thanks you for the help ;)
editing sheet cells in the edit bar
if I overwrite & hit return, the cell remains *un*edited :(
Macro Disappeared.
I have had a sheet with a Demo VBA-Macro since may 2011 that I occasionally start. It is a demo for an interview that I still sometimes use as an example. After this my macro has disappeared from the file and its history. So even if I go back to versions from 2011 the Macros/view reports the sheet as not having any macros. I am wondering if the location where the macros are stored may have become unavailable. I then opened another sheet with a macro, it had disappeared too. Am I the only one?
Can't Create A Piechart in Zoho Sheets
Hi there I'm having problems creating a simple piecharts in sheets. I have a column that tracks 4 different values. I want to create a piechart to show what's the percentage of each value based on the total number of entries in that column. In MS excel, I just have to highlight that column and insert a pie chart. When trying to do the same with zoho, I get 'No chart recommendations for the selected data range'. And when I select piechart, the preview on the right show's nothing. Would appreciate
Zoho Sheets - Sorting cells by Color & Sorting Text By Color. (Not
Filter)
Hi, Is there a way to sort cells by color and by text color, similar to Excel? Cell and Text can be filtered by color. However, this is not helpful because it isolates ("filters") the cells or texts of the selected color/text and hides all others. I'm looking to sort by color, for example, sorting by cells with red text on top etc. Is this possible?
Timesheet with Balance Due / Formula
I'd like to create a timesheet for an employee, to keep track of their hours, total pay, and current balance due. Below is a screenshot with more detail. I'd like total hours to display all of the results B6:Bxxx. Total Pay will sum all of the values from C6 and onward. I'd like the "Pay Due" (C3) to show all of the balance due for those cells that don't have a pay date listed. With the example above, I'd like it to display "5" but then when a date is entered into the "pay date" column for that
Zoho Sheets 503 Error
Zoho sheets have been unavailable since this morning. I can't open any sheet but docs and presentations are working. Any ideas? Thanks.
Issue with a Sheet after yesterday Connectivity Issue
Hello there guys, As of today we're not being able to manipulate an specific Sheet with Pivot Tables (and filters on it) I've attached a .mp4 showing the problem itself Briefly the problem is that when we try to change the filter itself it's not doing anything or randomly showing an Error Message that implies that we cannot modify a Part of a Pivot Table. Please let us know how to fix this as remaking this whole Sheet is not viable for us currently. Thanks in advance for your support Kind Regards
Alt Keyboard Shortcuts
This is key for me as a financial analyst, and would make things much faster.
Can't able to scroll down to excel
I've created/uploaded excel sheet, but now not able to scroll down, is there any setting where its lock.
zoom?
how do you change the zoom on the sheet?
Temporary glitch in STOCK() function.
Dear users, Due to the unexpected termination of stock data API service from Yahoo! Finance, we are sorry to inform you that the STOCK() function in Zoho Sheet will be temporarily disabled. The STOCK() function will return #ERROR! from our next update. We're working on bringing back the function and will update you once we're done. Please bear with us until then. Thanks, The Zoho Sheet Team
Meet the latest feature of Zoho Sheet: Lock Cells
We are happy to announce the release of one of the most awaited features in Zoho Sheet. You can now lock the cells that you wish to keep secure. Once you are done with editing cells, you can lock them so that they won't be modified anymore. We believe that this feature will be a great addition to our existing set of collaboration features and is intended to improve your collaboration experience. You can access this new feature Lock from Data tab. Apart from being able to lock individual cell ranges,
New forum, closer community, better experience—Zoho Sheet
Hi Everyone! We've been making a lot of changes to Zoho Sheet behind the scenes, and all these enhancements will be out in a few more days. As a first step in moving to a closer community where our team and users stay connected, here's the new Community forum exclusively for Zoho Sheet. Follow the page to see all the announcements, get answers for all your questions, post ideas, and learn some tricks that can help you create powerful spreadsheets quickly, and become a spreadsheet expert! Not
Grey background appearing for Charts when a Zoho sheet is exported to xlsx
When a Zoho sheet having charts is exported to xlsx or xls, a grey background is seen for the charts in the exported spread sheet. Please refer the attached screenshot. Could you please let us know if this could be fixed ?
Freeze panes disappearing/lost in the exported xlsx
When a Zoho sheet having a Freez panes is exported to xlsx or xls, the exported sheet does not hold the freeze panes intact & is lost. Please refer the attached screenshot. Could you please check.
No Zoom Button
Hi, I wouldlike to zoom in and zoom out my zoho spreadsheet file but unable to find that button. Can you help?
Conditional formatting: before/after "today" not available
When setting conditional formatting, it only allows me to set a specific calendar date when choosing "Before" or "After" conditions. Typing "today" returns the error "Value must be of type date". Is there a workaround? Thanks for any help!
Scroll time within the sheet and general delay is extreme
Hello, I've been using Zoho in China for the last one year. The experience with Zoho sheets has just only gotten worse. Every scroll takes 5-10 secs. Every cell entry takes 4-5 secs. Earlier i had gotten replies that it is due to "The great firewall of china". But thats is incorrect because: 1) I have tried using VPN servers from various countries which the same result. Even with different internet service providers. Basically all permutations and combinations. 2) I travel back to India and the experience
VBA Function
Users have been asking for the last 7 years regarding the use of Public Functions in Zoho. Has this been implemented yet. If so, how do you call the function within a cell? If not, why is this important feature not available?
hiding rows and columns
Hi Just signed up to the service, like the plugins ect, but there is no support for hiding rows and columns. i have uploaded a sheet from excel which had hidden rows and columns, which then all became visible. there is no feature to hide, will you be supporting this in future?
Trigger SMS when Cell Value changed in ZOHO Excel Sheet
Dear Members, We are into Overseas Recruitment Company. We conduct interview frequently and maintain Candidates data in Excel sheet. Now we want to maintain that Excel sheet in Zoho Docs (Excel Sheets) We have columns like below Candidate Name Position Mobile Number Status (in Status in the pre-defined values like(selected , not selected, offer declined values) If I select the Excel Cell Value as Selected then a SMS should trigger to the Mobile Number entered against that Candidate. Can we do that
How Do I Delete a Zoho Sheet?
How do I delete a Zoho spreadsheet and send it to trash? I no longer see an option to do that. Thanks
Looking for a quick alternative solution to sharing individual sheets like Google Spreadsheets's import range function
Hi. First, I want to comment that I greatly enjoyed using Zoho sheet last year and this spring. As a middle school teacher who loves excel for managing grades, Zoho sheet was a valuable product for me as it allowed me to output grades to individual students and help them to keep track of their progress. However, since the update, I am no longer able to share individual sheets with others, making Zoho spreadsheet now useless for my own needs. But I like Zoho and would like to say with Zoho. I understand
New iOS Sheet app not working
The most recent iOS Sheet app version launches and then quits. I have to delete and re-download every time to edit an existing sheet. Is there any way to roll back to the prior app version? TIA, -mike-
Connection to an external REST API?
Hi! Is there any way to connect to an external service API from within Zoho sheets? I haven't found anything and I don't think we can do it with Zoho Sheet's VBA implementation either. Does anybody know a way? Thanks!
Unknown function: Find
Hi There, Here is the code: Const WHAT_TO_FIND As String = "Supplier" Dim ws As Excel.Worksheet Dim FoundCell As Excel.Range Set ws = ActiveSheet Set FoundCell = ws.Range("J:J").Find(what:=WHAT_TO_FIND, lookat:=xlWhole) If Not FoundCell Is Nothing Then MsgBox (WHAT_TO_FIND & " found in row: " & FoundCell.Row) Else MsgBox (WHAT_TO_FIND & " not found") End If Here is the Error Msg: Unknown function: Find Why? And please don't tell me that the Find
drmartell@gmail.com
I can no longer check or uncheck check boxes in my spreadsheet when using Google Chrome. They do continue to work in Firefox. This timing seems co-incidental with the release of the updated iOS app which now supports single clicks to change check box state (which it didn't previously).
Zoho Sheet bug on very basic formatting !
A new very annoying bug has been introduced on Zoho Sheet a couple of days ago (beginning of February). Zoho is now UNUSABLE for most sheets. A text cell with characters exceeding his length, in ANY kind of spreasheet, has to cover the left side cell IF it's empty. Amazingly, if you go to that cell and press DEL to be sure it is empty, the formatting works again... BUT if you close and reopen the sheet, or you import a new one, all the empty / emptied cells are back "non trasparent". Hope you fix
why wont my spreadsheet print
i select the print area, click print and am then taken to a blank screen. Please help
Problem with the "Format" command
My code is: sub Hora_Actual() ActiveCell.Value = Format(Now, "dd/mm/yyyy hh:mm:ss") end sub The time is incorrect and the time format is also incorrect. Why ? My sheet here: https://docs.zoho.com/sheet/published.do?rid=566b173d0bfc132354f3ea3445bec13ef8da5
Embedding a spreadsheet in a website problems
I am having trouble finding information on how to work with embedded spreadsheets. I have embedded a spreadsheet on a website and realize there are many limitations. I want to know if when you embed a spreadsheet, how do you save the data entered? I thought it would automatically save but it does not. Is it possible to edit and save or ready only?? Any help or reference to any information regarding this would be appreciated.
Your edit is not applied to the document. Please try again later
Hi, I can't edit my Zoho sheet. I am always getting this error message. I am adding some details to the Manage Data Validation. And it won't save. Please help.
Index/Match formula
Hi, Can anyone help me with my formula: =INDEX(BackOfc.A3;MATCH("Richard Ponce";BackOfc.$B3;0)) it doesn't seem to work on zoho sheets. Is that how it should be written? Also if I could include the IFERROR formula on that one, please help me with write that out. Thanks..
Next Page