Pull Data from One Sheet to Another

**FourNines** · 12-27-2011, 05:25 PM

Hi Folks,
I am trying to create a macro that will pull some data from different cells in one worksheet and posting it to another worksheet within the same workbook. I am trying to get my head around coding this (total Excel noob here) but having a heck of a time.
If someone can take a look at what I have and let me know what I am doing wrong, I would greatly apreciate it.
Thanks.

Please Login or Register  to view this content.

**Richard Buttrey** · 12-27-2011, 05:59 PM

Hi,

You may not even need a macro since probably using the COUNTA() function would be enough to return a value for an empty cell. Difficult to comment with certainty without actually seeing your workbook.

However the syntax of your code is wrong.

Instead of

Please Login or Register  to view this content.

try instead:

Please Login or Register  to view this content.

Regards

**FourNines** · 12-27-2011, 06:21 PM

Richard,
Thank you for taking a look at my code.
I changed the code as you suggested but it is still not pulling and posting the data. I went ahead and posted the workbook.
Regards,
Joe

**Richard Buttrey** · 12-27-2011, 09:04 PM

Hi Joe,

See the attached. This is the technique I generally use for stuff like this. Note the additional two rows on the Purchases Sheet with A2:M2 named 'New_Record"
Now the two line macro simply copies this row and pastes it as values to the data sheet.