Related Posts
Hi Fishes!!
Need suggestion from you all.. I will be having HR discussion with Wells Fargo on Tuesday where initially before process started ,expected CTC was told 36(33 fixed+3VP) LPA and I agreed to.
Yoe 9.8y
Tech stack Angular,.Net Core Csharp
Do you all think that this is fine package or any room for negotiation?
I am holding another offer of 32LPA on which this was stated as expectation
I feel being lowballed. Any suggestions or advise?
Wells Fargo HCL Technologies Accenture KPMG
What one thing you like about your organization?
How do companies now view candidates from Meta?
Additional Posts in Excel Genius
What are the most typical models you all build
New to Fishbowl?
unlock all discussions on Fishbowl.
Subject Expert
You mean like you have a row with "A B C" and you want to "move it" to another sheet?
If that's the case, you can either:
- Copy/paste values
- Link the cells through reference (cell 1 = cell 2)
- move the whole tab (very similar to copy/paste, but more robust (it isolates all calculations that doesn't have references externally to that tab)
I think that's pretty much it. You could have more complicated ways to reach that, but those would be pretty much based on the first 2 (e.g.; use VBA to either get the values, or link the cell and then breaks the link)
Is there a specific problem that you're having with copy/paste?
Awesome thank you I will look into it!
use index match formula or an array formula!
Do you have an example of what you are looking to do? If it’s to add to a second table that shares a common data point. You can create a Merge Query with Power Query. Other that that it can be done with copy paste, index/match, Vlookup. But it depends on your set up and your objectives.
Vlookup
I work with student data for a school. Once inputting data fir students that is complete, my goal is to have their row auto moved from an incomplete sheet to a complete sheet to focus on who is left. The complete sheet is for another faculty member.
Subject Expert
Ohhhh makes sense now
Excel is not the best tool for that. I'd recommend using python or other friendly language to populates a .csv or .xlsx file. The code shouldn't be that hard, and probably there's something ready online (stackoverflow probably).
In case you would need to use Excel for that, the best way would be to use Power Query to "concatenate" lots of files with one row into one (you need to save separate files in the same folder). YouTube has some videos explaining how to do it. Technically you could also use VBA for that, but it would be harder than power query, and probably less efficient
Indirect Function should work if you have the latest version of Excel