Good evening everyone, I am looking for a way to move a row of information from one sheet to another after data has been collected. Is there a way to do this without cutting and pasting rows?

like
Posting as :
works at
You are currently posting as works at

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?

like

Awesome thank you I will look into it!

like

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.

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

Related Posts

3/6 analysts on my team (myself included) did not get a bonus this year without any good explanation besides overall poor team performance. What would you do?

like

Happy NYE! Does anyone work at Meta (Facebook)? If so, would you be willing to refer me to a job? I'm happy to share a write-up on my qualifications. DM if you can! 😊

like

Hey Fishes,

Have anyone opted for extension in Wfh? How to apply for it? Did you get extension?

TIA

like

My boyfriend has given soo many red flags over the past year but we’ve been trying to make it work. Heated arguments consistently every other week. We disagree on a lot of “expectations” in a relationship. He can be controlling and quick to get angry, and I just can’t take this emotionally anymore (esp when he blames me for making him angry). Tips on getting through the break up convo when you know it’s the right thing to do but you love them & it hurts like hell to end things?

like

Is anyone familiar with Woodside Capital Partners?

like

What is the base salary offered by Amazon to 7 yoe ?

like

How to transition into a manager role when you promoted? How you approach the leadership team to own more responsibilities and opportunities?

like

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

like

Anyone took CFP exam? How hard is it compared to CPA? And how many hours prep?thanks

like

Fellow glasses wearers,

Are you glasses fogging up when you wear masks?
Any suggestions? (Besides wearing contacts)

like

What does a mental health day look like for you? Took one today & it was the best thing I’ve done for myself. Bonus Q: did you own up to it being a mental health day or did you go to “the dentist"

like

Every time I pull an all nighter my room ends up being a trash can. 🤦🏻‍♀️

likefunny

What one thing you like about your organization?

like

My HR round was completed on 14th November and asked to submit documents for mindtree but i have not received any offer letter, when can I expect my offer letter,? should I wait for the offer or not?

like

Are PE firms licking their chops looking at Twitter?

like

I’m currently doing my first drug launch and wanted to ask if it’s normal to be working 15+hrs a day during a launch?

like

Boy in the security lane just raised his hand to ask TSA a question, which she smiled and answered. Adorable.

likefunny

How do companies now view candidates from Meta?

like

In the midwest, talking to a small agency. If I take a FT role and possibly move in a few months, wondering if they’d be open to me staying on remotely. Everything’s been remote for them for a while anyway and will likely continue to be. Any thoughts on how to approach this scenario? Want to do right, but don’t want to be overly precautious either.

like

Switching careers into UX, recently finished a UX bootcamp. I can’t get a straight answer from the instructors on UX job title definitions and responsibilities (cont’d)

like

Additional Posts in Excel Genius

What are the most typical models you all build

likehelpful

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

Please help. I was recently hired by a Venture Capital firm that uses MacBooks instead of PCs. I’m extremely efficient with Excel on PCs and am struggling with the transition to Mac. Do any Mac users have a list of keyboard shortcuts that they use frequently, or any other tips/tricks?

likefunny

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

like

[shortcut genius] how can I use a keyboard shortcut to simulate the double-click on the cross in right low corner that extend your formula only to the row you need (ctrl+d will go too far)

likehelpful

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

What are the most annoying things for you in old-school excel users?
I’ll start:
1) vlookup 2) concatenate 3) inability to work with file versions, therefor constantly locking file from changes

like

I am having difficulties getting my (Return on ad spend) column displaying correctly. The source data is shown in currency but on the pivot table I am only seeing count and percentage options. Any help would be greatly appreciated.

Post Photo
like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

I really need some help.
What shortcut inverses my
Ctrl + [ aka Ctrl + {
which jumps through a cell to the source? How do I jump back? Manually isn't practical for a 50+ tab sheet

like

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

What are your top Excel ninja tricks? Ones that few people know...

like

Hey, tips for where to look for good excel cheat sheets online? :)

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal