Having read my post I dont think Ive explained very well! Basically, depending on if criteria is met on the first worksheet (Entrants) I want to fill those entrants into the the next worksheet (Spaniel Special Puppy) filling it in from the top. At the moment an empty row is left on the spreadsheet (Spaniel Special Puppy) where criteria hasn't been met, which I dont want!
Please Login or Register to view this content.
Last edited by dadrew; 09-02-2012 at 01:40 PM.
Corbinsbere Gundogs Competition.xlsI have attached my spreadsheet in the hope that someone can help me. Many thanks
Which is your correct sample file? The one in post 2 or in post 3?'
The one in post 3 does not match your question.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi its post 2, I had a problem with uploads, could you delete post 3 for me please. Many thanks
Done.
Try this code
Copy the Excel VBA codePlease Login or Register to view this content.
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button
OK I did this and what it was doing was inserting the data at the bottom of current data from row 52
Yes, thats because there are formulae in your sheets right uptil row 51. Once you clear them out, the data will fall in place.
OK I understand, so I clearly need the formulas in there, so is it possible to automatically add the formulas when the record is inserted.
In addition if I run the code more than once it just adds the same records over again, really it should only add any new records!
Last edited by dadrew; 09-03-2012 at 08:08 AM.
Formulae in G & H columns only right?
Yes thats correct!
Entire updated code -
Please Login or Register to view this content.
Superb, thanks so much for alll your help.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks