Wrox Programmer Forums
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old July 22nd, 2011, 07:35 AM
Registered User
Join Date: Jul 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Hope you can help


First time here and hoping you can help me.
I have little to no knowledge and have been trying my level best to google this before I ask the question. But I just can't seem to get my spreadsheet to work correctly.

What I have is a workbook with several sheets of data (Rows and Columns).
Each sheet is manually updated by importanting data from a website (Copy and Paste)
The number of Rows will always change but the number of Columns will not.
Each sheet has exactly the same number of Columns, however we can not simply just copy a entire row, as there may be notes.

For example Sheet2 may be 6 Rows 8 Columns this week, but next week Sheet2 may have 16 Rows.

Sheet 2|| Sheet 3|| Sheet 4
A B C|| A B C|| A B C
1 X X X|| 1 X X X|| 1 X X X
2 X X X|| 2 X X X|| 2 X X X
3 X X X|| 3 X X X
4 X X X||

Now for the tricky bit

I want to consolidate all this data on one sheet, but it needs to clear the existing data from that sheet.

Now I figure this is the easy part since I can input a static cell, with a value, on the sheets 2-4 and have a column insert that value into a column on the Sheet1(The consildation sheet)

So let me explain;

I want to push a button and it must search Sheet1 from Row 2 (Row 1 is headings) for data in a Column, that matches a Cell in Sheet2 and delete that row on Sheet1.

It must then copy Row 2 to "X" from Sheet2 (Column A to G only) to the end of the Rows in Sheet1.

Thank you in advance for all your help.

Last edited by garethfedwards; July 22nd, 2011 at 07:38 AM..

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hi hope someone can help here!!! mike_remember ASP.NET 1.0 and 1.1 Professional 2 October 31st, 2006 09:14 AM
I hope it could help for right-click Yahoa Javascript How-To 0 December 11th, 2005 02:58 PM
Boy I sure hope the code is better hesterloli Wrox Book Feedback 3 February 10th, 2004 10:56 AM
Hope if any one can provide some help RahilPatwa All Other Wrox Books 0 November 8th, 2003 01:31 AM
some questions - hope someone can help ywith Access 2 June 12th, 2003 11:42 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.