Copy/paste values if the cell next to it is empty every month

[Mortenhoey]

Is there a way i can copy paste specific rows to the excel ark. The things i need:

- copy paste e3, e4, e9, e13 and e15 from mappe2 (book) to mappe 1 (book)
- has to copy the value in the given row if the cell next to it is empty
- the macro has to be applied from mappe1 (book)
- next month the may values (which is coming, later at the month) and run it again so it is the may values which copies to mappe1 (book)
- The workbooks has to be open

So the point is to always copy paste the lastest value from mappe2 (book) to mappe 1 - month by month.

In mappe1 there are maybe more variables to come to maybe in two months there has to e3,e4,e9,e13,e15 and add e5 and e14.

So if I can put more rows in the macro for future months copy paste it would be perfect.

I really can figure out to make the macro for choosing a value if the next cell is empty and the same when pasting it in mappe1 (book)

Link to: Photo

Thank you for the help.

 

[Mortenhoey]

I cant make it work.. When I choose the rows it says "invalid section" and there is nothing i can do to make i work.

 

[kanadaaa]

You need to choose cells from column A, as the input box says.
Read the instructions carefully.

 

[Mortenhoey]

I tried from Column a. Is there a way i can send you the real workbooks then it would make more sense.
Because the one i linked too is just an example.

 

[kanadaaa]

You could use DropBox or https://easyupload.io/
I’m afraid I didn’t fully understand your needs from your explanation by words.
Maybe you can post images or something and give a concrete example of what you need.
I guess this can be done without having to share your original workbook.

 

[Mortenhoey]

I need a macro to look up a given row:

- The macro should be run in the workbook: photo 1
- All my data is in the workbook in photo 2 (maybe more workbooks to come where I need data from)
- In photo 3 is all the data I need for the given month. The cell number in photo 3 is from february and now i need the data from march (location of the given data in the workbook in photo 2).
- Then i fx need to look up a given row, lets say xDSL @ 50 Mbps in row 145 then i need to copy the value in CL145 and past it into the workbook in photo 1 in the right cell.

Therefore i thought it was easier just to make a macro which lets me choose the workbook I want to copy from and which row and paste it in a workbook where i define which row it has to be in.

Photos is attached

 

[kanadaaa]

Hey, I really don’t like your cross-posting.

VBA - Copy/Paste last value in column if the next cell is empty

HI I need to copy the last value in the column every month and copy paste it into another document which shows the KPI for the current month. So if you look up the picture i need all the values from mar2021 to be copied this month and apr2021 next month. Is it possible to make some kind of VBA...

www.mrexcel.com

Copy/paste values if the cell next to it is empty - OzGrid Free Excel/VBA Help Forum

Is there a way i can copy paste specific rows to the excel ark. The things i need: - copy paste e3, e4, e9, e13 and e15 from mappe2 (book) to mappe 1 (book) - has to copy the value in the given row if the cell next to it is empty - the macro has to be…

www.ozgrid.com

Your post in #25 is even worse because you’ve posted exactly the same comment in the first link above.
Did you really read Fluff’s post in #3?
What are you going to do if someone on the other threads give you a solution while I’m working on this matter here?
Will my efforts just be a waste of time?

 

[Mortenhoey]

Hey, I really don’t like your cross-posting.

VBA - Copy/Paste last value in column if the next cell is empty

HI I need to copy the last value in the column every month and copy paste it into another document which shows the KPI for the current month. So if you look up the picture i need all the values from mar2021 to be copied this month and apr2021 next month. Is it possible to make some kind of VBA...

www.mrexcel.com

Copy/paste values if the cell next to it is empty - OzGrid Free Excel/VBA Help Forum

Is there a way i can copy paste specific rows to the excel ark. The things i need: - copy paste e3, e4, e9, e13 and e15 from mappe2 (book) to mappe 1 (book) - has to copy the value in the given row if the cell next to it is empty - the macro has to be…

www.ozgrid.com

Your post in #25 is even worse because you’ve posted exactly the same comment in the first link above.
Did you really read Fluff’s post in #3?
What are you going to do if someone on the other threads give you a solution while I’m working on this matter here?
Will my efforts just be a waste of time?

I just thought there was no problem if like Fluffs said there was no problem in cross-posting if they knew it. The conversation with Zot is like 2-3 weeks old and we haven't found a solution so i thought I might try again, too see if other could find a solution for me.

My bad, I understand if you dont want to work on it anymore. But I just really need to find a solution and I have searched for it in a month.

 

[Mortenhoey]

And I closed the conversation on Ozgrid yesterday because i really like this forum.

 

[kanadaaa]

I just thought there was no problem if like Fluffs said there was no problem in cross-posting if they knew it. The conversation with Zot is like 2-3 weeks old

You never let me know you have a thread on this forum for exactly the same matter, and Zot’s latest comment is only hours old.
I’m not talking about the forum rules, I’m just sad that you’re treating us like free code-writing machines.
I wish you could think carefully about what I mean by this:

What are you going to do if someone on the other threads gives you a solution while I’m working on this matter here?
Will my efforts just be a waste of time?

FYI, what Zot says on the other thread is everything:

Don't really understand what you were trying to say here. I have no idea how to determine which cell to copy to which destination cell. Perhaps you can give captures of source data and also destination data and explain how you decide which data to transfer if possible to do it automatically.

Basically he/she has asked you exactly the same thing as I asked you above.
We don’t have enough information on your needs , which is why you’re having a hard time finding a solution for this.
The images 1 and 3 you posted in #25 may look alike at first glance but they don’t really.
(Presumably) Zot and I still have no idea on:

lets say xDSL @ 50 Mbps in row 145 then i need to copy the value in CL145 and past it into the workbook in photo 1 in the right cell

As I asked, WHERE is the value in CL145 supposed to go? (“the right cell”, this is what you really should make clear.)
Your 3rd image doesn’t have room for it.
And you’ve never said you need the cell addresses from which you’ve retrieved data.
Also, why does it have to be that the value to be retrieved is the one in CL145 while CJ145 and CK145 are empty?
In other words, how do you decide the data to pick up?
Moreover, image 1 has a row that has “xDSL @ 50 Mbps” but image 3 doesn’t.
We obviously can’t figure out how the destination cell is decided from this.
Even more, you never told us that the criteria for copypaste are the values in column G.
At this rate, no code will work because columns need to be specified in any given code.

I’m pretty sure no one will be able to help you out before you learn how to be polite and make the points above clear.

 

[Mortenhoey]

You never let me know you have a thread on this forum for exactly the same matter, and Zot’s latest comment is only hours old.
I’m not talking about the forum rules, I’m just sad that you’re treating us like free code-writing machines.
I wish you could think carefully about what I mean by this:


FYI, what Zot says on the other thread is everything:

Basically he/she has asked you exactly the same thing as I asked you above.
We don’t have enough information on your needs , which is why you’re having a hard time finding a solution for this.
The images 1 and 3 you posted in #25 may look alike at first glance but they don’t really.
(Presumably) Zot and I still have no idea on:

As I asked, WHERE is the value in CL145 supposed to go? (“the right cell”, this is what you really should make clear.)
Your 3rd image doesn’t have room for it.
And you’ve never said you need the cell addresses from which you’ve retrieved data.
Also, why does it have to be that the value to be retrieved is the one in CL145 while CJ145 and CK145 are empty?
In other words, how do you decide the data to pick up?
Moreover, image 1 has a row that has “xDSL @ 50 Mbps” but image 3 doesn’t.
We obviously can’t figure out how the destination cell is decided from this.
Even more, you never told us that the criteria for copypaste are the values in column G.
At this rate, no code will work because columns need to be specified in any given code.

I’m pretty sure no one will be able to help you out before you learn how to be polite and make the points above clear.

I didn't want to post these pictures because it was classified information, so i had to manipulate two worksbooks which should do the same. The rows in photo 3 match the location in photo 2 and I need those location to be copied into photo 1.

Sorry cant says it better. I dont know how to say it better.. (again my english ins't that good).

So fx:
Row 155 (photo 2) the last value in the row (CL155) need to be copy pasted into photo 1 b2. One is done. Then I need to do it for the rest. So if it possible to make a macro where you make on and i can put more into the macro coding, the job i done.

I have uploaded new photos