Hey all, for VBA what would the code be for searching for a specific value in column A and once that value is found go to the next row, do a loop that basically copies and pasted that value into Column C, the next row would then be copied and pasted in column D, then next to E, F, and G then back to C…. Until another specific value is found?

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

I’m just here for the character development of you figuring out this on your own lol

funny

Sorry I can’t help! My knowledge of VBA is null. I just subscribed to the post hoping to learn something from the replies 😅

like

Update: was able to establish the beginning and end values and I am able to return the count of rows between those two parameters. I am either going to assign a value 1-5 or figure out how to do the copy and paste portion.

like

Update 2: I now have a dynamic range finder based on search functions. I am going to create a loop where it assigns a number at the start of the range and if it hits 5 it will subtract by 4 (to reset the value back to 1).

like

Let me know if that’s unclear.

-unique row (value searched “paper”)
(Copies and pastes rows into 5 separate columns and will cycle and repeat until new unique row is found) value searched “rock”.

like

Update 3: was able to assign the data to a fixed number, I just have to write a loop function that places a condition on every time the fixed number hits ‘1’ create a row and push it down.

like

Can anyone help me, what is the code where I copy and paste based on the value of a different cell (cell value is 1 and then move down one by using offset?)

Hmmmm, how about this i already have my column number by doing an auto fill 1-6, all i have to do is create an artificial row number by saying every time column D is 1, do I+1 in column E, else I? If I can create the row indices then I can just do an index match. Also, how would I have it search the whole column and to skip the empty rows (I made this to be adjustable). I also tried to do a multi statement function but for some reason it isn’t pasting to my other sheet.

Following this thread not because I can help or I have a similar problem. I just want to understand what the heck they are even trying to do.

I basically have most of the code done, I am just stuck on the last part where I need to count the rows. Basically I have a repeating sequence from 1-6, every time the sequence hits “1” in column D, it increases the value of the row in column E by 1 (this is to mark a new row). If I can get this done, I can just Index match and be done with the task.

Related Posts

True story 😂

Post Photo
funnylikeuplifting

Are you guys have come to pune or still working from home town?

I'm looking for someone to run Adroll for a startup with a $5k a month ad spend. How many hours a week will that take them and how much should I pay them?

like

I am an email marketing specialist. I am approaching my one year at my new job. I have been going above & beyond. I have been recognized by my boss that I have been doing great as well. I have been implementing new strategies, completing all assignments on time, and I do the most in all of our meetings, interviews and business events. How much can I ask for a raise?

like

Hello Fishes,
I am selected for Data Security- Guardium role in Infosys,
YOE- 2.5 Yrs
Current CTC- 9.7lpa
I have knowledge in fields of cloud as well.


How much hike should I expect and how much should I ask for?

Thank you

like

Hi IBMers ,

I joined IBM last week and was checking my PMR which is 1.107
Band 7B , Senior Data Engineer
Is it on the high side? And does it have any impact on anything?

like
like

For internal promotion with title increase... do you start with your pitch first or the $. My pitch will include market rate, value I'm bringing and will continue to bring with examples. Wondering if I should also include how we have been having a hard time filling positions so the market is in employee favor for my role as well as inflation? Should I go into granular detail on the math done to get to my #such as market average for my role the % increase I had for my last promotion etc

like

Anyone have any small jobs they need help with?

Best team names?

I had a psych meet the other day for VA stuff in expanding my PTSD and anxiety issues - it opened some traumas; childhood, Iraq, divorce, alcoholism, suicide attempt. I cried a few times explaining then to now. I’ve been in therapy for years which has given me all the tools I’ve needed to work thru it all. I prepped for this meet knowing it was coming, but it resurfaced alot of memories. She ended saying, “you’re doing great.” I needed that so much. Thank you for listening and you’re not alone.

like

Here’s a list of FAANG list of what you drive if you work there. Apple:Tesla, Netflix:Subaru, Amazon:Jeep, Google: Lexus, Facebook:Kia Tesla:Mars Rover

likefunny

Hello everyone, I am a nonprofit consultant. I coach and train on fundraising and nonprofit management . I am looking for people to recommend my services to nonprofit organizations. Thank you .

likehelpful

Can some help me with Transport facility details for MasterCard Pune.

1. What is radius of Transport facility i.e 20/25/30 KM from office?
2. Is there any policy / restriction i.e within Pune city limits etc?
3. Is Transport provided to all employees or only to those who work in shifts?

My previous company provided Transport till 40Km. We had employees coming from Punawale and Piragut to Kharadi office.
I've recently shifted from Kothrud to Bhukum.
(I.e 25 km from office) will that a problem.

like

Interviewing in the Cloud Economics org at Amazon. Can anyone shed lights on what type of questions to expect during the HM level interview? This would be my first time speaking to the HM after the headhunter call.

Can anyone share what the process is like for project manager roles at Facebook (Meta)?

Passed screenings, on the way to the hiring manager.

What I expect:

* Why Meta
* Talk about project experience
* Tell me about a time

Might you have a success story to share?

Thank you

like

Any thoughts on the Chopard Alpine Eagle? Seriously considering it...

like

“Do you think art directors look at images online for inspiration?”

funnylike

Hi all, have you seen the consultinghumor survey on income? What is your opinion on it?

Hi,

Please does anyone know how much does Alixpartners pay its MBA internship and post MBA consultants in EI for London office?

like

Additional Posts in Excel Genius

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

This isn’t exactly an excel question, but is there a way to clear the “last modified by” history on an excel document in SharePoint? Accidentally opened a file i shouldn’t have.

likefunny

Is there a trick to analyzing more than 1MM rows in excel?

likefunny

Anyone work on a Mac and use parallels when in need of excel? If so, does it work or is it a big no-no? My work going forward will not primarily be excel, but I have to use it on weekly/monthly basis. Might also have to use some Power BI. Would love to go back to working on a Mac but excel has stopped me from buying one…

like

Mac iWork Numbers question: is there a GPS co-ordinates function? Looking to pull location information & calculate distances between locations in the sheet.

like

Formula to convert the date on the left to the date on the right? I’ve been using text to columns then concatenation but I feel there must be a better way...thoughts? Thanks!

Post Photo
likehelpful

Excel noob here. Can anyone help me write a formula where if a range (column) contains a particular value, then return a value in a different column of that same row into a cell?

like

I’ve got some lookups to do but inconsistent unique identifiers (names with Bob G01 vs Bob G1). More experienced fish, what’s the best way to perform look ups with this kind of unclean data? Got a few

like

When you F2 a cell to display cell references. Is there a way to navigate to that cell reference quickly without having to scroll and find the highlighted reference cell?

Thank you

like

Best way to learn Spotfire? Just watch YouTube videos?

If I’m creating a comp set and a row of numbers will not adjust the number of decimals no matter how many times I adjust it in the “format cells” window, what could be the reason for this and how can I get around it

like

I truly appreciate this group.

Post Photo
likefunny

why is index match superior to vlookup?

likefunny

Anyone know of an excel Add-in (preferably free) that lets tracking formula in a cell?

like

I have a date I need to match to an array of strings (that represents dates). Eg matching 6 nov 20 to (20201106, 20201107, etc. ). I can convert my date into this format using text(date,”yyyymmdd”) but then my lookup tried to match “20201106” with that list and the “ causes a mismatch. Any hints, and I would prefer not to change the array format?

like

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

like

Can anyone recommend a specific video on pivot tables?

like

Help! Excel won’t let me navigate using my keys anymore, arrow keys and enter will not move me to the next box. This is happening on multiple docs. Please explain how to fix this as if you’re talking to someone who is excel dumb (because you are).

like

Does anyone have experience setting up automated queries on Excel for Mac? I am trying to automate a paid search pacing document but am running into an issue with the Excel Power Query not being able to log in to Search Ads 360.

like

Does anyone use XLOOKUP over Index Match? Why /why not?

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

Scan your QR code to download
Fishbowl app on your mobile

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