User Profile
bcsteeve
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Re: Office Scripts in Excel: Can I have a button in worksheet 1 that updates a cell in worksheet 2?
I had thought you try that, but a) when I used find, the macro stopped recording and b) find what? Find require that I know what I'm searching for. "Adapt to your needs" is the problem I'm having.1.2KViews0likes1CommentRe: Office Scripts in Excel: Can I have a button in worksheet 1 that updates a cell in worksheet 2?
Now, how to do that if I don't know E1 is E1? let's say I have two columns on Sheet2: ID | Data 1 | This 2 | That 3 | The other And I have another cell that references which ID we're working with (let's say $F$4). How do I reference the correct cell (E1 in your code) so that it points to the row in Sheet 2 where the first column (ID) matches the value shown in $F$4? Thank you.1.3KViews0likes3CommentsReference a cell by its contents?
As a formula, I'd generally use index() along with match(). How does one reference a cell by its contents in Office Script? On WorkSheet1 in Column A I have a list of non-unique names, already sorted. In Column B I have some data I want to change. On WorkSheet2 I have a named cell "ID" at $B$2. This is used to determine which row in WorkSheet1 we're working with. I want to find the FIRST row which contains "ID" in Column A. On WorkSheet3 I have the new data in A1 to be copied to WorkSheet1 (at $B$x) When I click a button on WorkSheet3, I want the appropriate cell in WorkSheet1 (ie. the cell in Column B which is in the row where ID first matches in Column A) to change to match what is in a WorkSheet3 $A$1 Thanks.527Views0likes1CommentOffice Scripts in Excel: Can I have a button in worksheet 1 that updates a cell in worksheet 2?
This may be trivial, this may be impossible. I was only made aware of the existence of Office Scripts yesterday and I really have no idea of their capability. I was trying to look through some samples but I did not come across quite what I'm looking for. Before diving further in, I want to ask if this is even possible. If so, and you can further help with the "how", that would be appreciated. I have a multi-sheet excel workbook. On "Sheet 1" I have data brought in from an external (non-Excel) source which exports a CSV. This gets updated daily, so every day I download the new data and paste it into Sheet 1. On Sheet 2 I have the results of that manipulated data from Sheet 1. I copy that and paste it back to the external source once I'm satisfied with it. What I would like to do, additionally, is have a button that I can click that replaces a specific cell in Sheet 1 with the contents of a specific cell in Sheet 2. The reason is because the source data only updates overnight, but in the meanwhile I'd like to keep track of what I'm doing in the day. There's a "days since updated" cell that, at best, shows "yesterday" and never shows "today". If I modify the data in Sheet 1, it can show "today", but I want that to be a simple click of a button on Sheet 2. Bonus: if that same button can save the cell's content to the clip board, it would save the user a keystroke. Note: We are locked out of using VBA (or else this would have been trivial). Thank you.Solved1.4KViews0likes6Comments
Groups
Recent Blog Articles
No content to show