VBA Simple Check if 2 cells matches and if that is true it will copy and paste data .

**Desotronics** · 05-09-2019, 04:48 AM

Hi There,

This must be very simple to make.
but i sadly lack the knowledge to produce this.

Here is my Story.

I need VBA to tell if A1 and A2 Equals (This is a date) than i need him to check in tab History if that date matches the date inside the cell than i need him to copy and paste the value of DATA C4 to C6 to corresponding date Column

But this can only occure after the button is pressed.

I have in A1 a today formula
I have VBA inputting Range("A2").Value = Date (this happens when i press the get data button this button will load data from different sources we need to do this on a daily basis)

The column data is where the data needs to be extracted and History is where the data must go.
This way we can see what the value does on a daily basis.

I hope this is understandable.

greetings !

**Richard Buttrey** · 05-09-2019, 05:39 AM

Hi

It's not clear to me what you're asking.

First of all we need to see the workbook you're trying to load. Please upload it.

Are you saying that the file you load looks like the data in B3:B7 on the Data sheet and that this will have a date somewhere and that date should be placed in A2?

Then finally the data you've loaded should be added to the appropriate column of the History sheet.
And if so which cells. C4:C6 or D4:D6 or something else?

As an aside your line of code

Formula:

Please Login or Register  to view this content.

needs to be inside a procedure. i.e. a

Please Login or Register  to view this content.

I'd also consider turning the history sheet through 90 degrees so that the dates are down column A and the values down columns B:D. This is a more 'natural' way of keeping a database and will simplify any future analysis you may require.

**Kaper** · 05-09-2019, 05:57 AM

If I understood well, ou may try such code:

Please Login or Register  to view this content.

**Desotronics** · 05-09-2019, 07:30 AM

Hi Richard,

Thanks for responding.

I can't upload the actual workbook it has sensitive information. It contains all the information of our Warehouses

The Information on B3:B7 is the actual information that needs to be copied to the date range.
the data that is being copied should be added on the Column that contains the same date. (sheet history)

so after pressing the refresh macro (lotsa loading and copy paste etc) than at the final stage of the macro i have inputted Range("A2").value = date.
I did this because i needed to validate if the excel formula (=today() equals the date that just has been printed by the button with conditional formatting.

So here i'll explain my question again.

I need VBA upon pressing my button (which allready exists)

to do the following. (this ofcourse after printing my date which allready exists)

Check if A1 matches A2 if so:
Copy data from C4 to C6
Paste it to the corresponding (date of today. because that's what both a1 and a2 do) column in worksheet History.

and that's it

hope its more clear now !

**Desotronics** · 05-09-2019, 07:39 AM

Hey Man,

This is exactly what i was looking for !

thanks for your time !

im trying to learn vba every now and than.
but also actually busy with understanding Excel itself

ty sir!

**Desotronics** · 05-09-2019, 07:51 AM

oof, almost there.

my c4:c6 isn't on the worksheet DATA but on one called Pivot.
the range If .Range("A2") = .Range("A3") Then / is on the worksheet DATA
(so i have 3 different ranges.)

:S

**Desotronics** · 05-09-2019, 08:07 AM

in suplement of my previous post i tried to bake this:

sadly it's not working yet

the yellow part is where it stops.

Please Login or Register  to view this content.

**Richard Buttrey** · 05-09-2019, 08:20 AM

Originally Posted by Desotronics

Hi Richard,

Thanks for responding.

I can't upload the actual workbook it has sensitive information. It contains all the information of our Warehouses

So here i'll explain my question again.

I need VBA upon pressing my button (which allready exists)

Just desensitise the data. We don't need to know the real names or contents of your warehouses. Neither do we need every single row of data, just a sufficiently representative example.

And neither did I see any button.

**Desotronics** · 05-09-2019, 09:27 AM

Hey man,

thanks for responding.

The dashboard that we got is way to big to clear out of information everything points to one another.

the setup that i uploaded is the same exact thing as what i work with without all the data. now updated with a button !

greetings

aaron

**Richard Buttrey** · 05-09-2019, 10:25 AM

Here's the code I'd use for the button

Please Login or Register  to view this content.

**Desotronics** · 05-09-2019, 10:33 AM

Originally Posted by Richard Buttrey

Here's the code I'd use for the button

Please Login or Register  to view this content.

Thanks man I will try this at work tomorrow

Greetings

Aaron

**Desotronics** · 05-10-2019, 02:32 AM

Hey richard,

i used the piece of code of Kaper.

and now it works

Please Login or Register  to view this content.

thanks for your help.

**Kaper** · 05-10-2019, 01:04 PM

Glad to hear it works, but please observe forum rules (there are just few):

Rule 2 says, that you need to include code tags around your code.

Please take a moment to add the tags to above post and previous one: https://www.excelforum.com/excel-pro...ml#post5117573

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No further responses shall be posted until this request has been fulfilled.)

VBA Simple Check if 2 cells matches and if that is true it will copy and paste data .

LinkBack

Thread Tools

Rate This Thread

Display

VBA Simple Check if 2 cells matches and if that is true it will copy and paste data .

Re: VBA Simple Check if 2 cells matches and if that is true it will copy and paste data .

Re: VBA Simple Check if 2 cells matches and if that is true it will copy and paste data .

Re: VBA Simple Check if 2 cells matches and if that is true it will copy and paste data .

Re: VBA Simple Check if 2 cells matches and if that is true it will copy and paste data .

Re: VBA Simple Check if 2 cells matches and if that is true it will copy and paste data .

Re: VBA Simple Check if 2 cells matches and if that is true it will copy and paste data .

Re: VBA Simple Check if 2 cells matches and if that is true it will copy and paste data .

Re: VBA Simple Check if 2 cells matches and if that is true it will copy and paste data .

Re: VBA Simple Check if 2 cells matches and if that is true it will copy and paste data .

Re: VBA Simple Check if 2 cells matches and if that is true it will copy and paste data .

Re: VBA Simple Check if 2 cells matches and if that is true it will copy and paste data .

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Populate cells with data from other cells if 2 matches are true

[SOLVED] Check values seperated by comma, if matches copy cells

Macro for WS/WB comparisons, and copy/paste two cells based on matches

Check if two cells are equal and copy,paste cell if true

Macro to Copy and Paste cells if TRUE

copy data of check box is clicked true

Bookmarks

Bookmarks

Posting Permissions