I cannot delete rows on the source sheet
I'm based in Port Moresby and my old man (dad) has a small guest house that
he is renting out to his guests that I went to help him do it using excel
Regards
Chris
On Tue, Jan 17, 2012 at 10:46 AM, dguillett1 <dguille...@gmail.com> wrote:
> Didn’t get a chance to fully look at it but have you tried simply
> deleting rows on the source sheet? Shutting down.
> Where are you and what is this for?
>
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Christopher Kevin <christopher....@gmail.com>
> *Sent:* Monday, January 16, 2012 6:17 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet!
> Help Please
>
> Don,
>
> OK I'll try to explain it more clearly:
>
> As per the file attached:
>
> 1) Data is entered into the "RoomReservations" Sheet using the "Form"
> Sheet as an excel userform. This "Form" Sheet contains the Following Fields
> as shown below:
>
> Booking Ref Ref001 Guest First Name Chris Guest Surname Kevin Guest
> Phone No 309 0478 Guest Email Address * * *cke...@gmail.com* Guest
> Country PNG Check In Date 15/01/2012 Check Out Date 17/01/2012 Adult
> Guests * * *2* Children Guests 2 Room Type Suite Room No 601 Booking
> Status Confirmed No of Nights 2 Rate 350 % Discount 0.25 Total
> Payment 700 Remarks Paid
>
> 2) After entering the data the "Add Bookings" button on the "Form" Sheet
> is clicked to transfer the data from the "Form"Sheet to the
> "RoomReservation" Sheet. The Headers start at row 6. The first entry is
> added to row 7.
>
> 3) To view previously added bookings the the following bottons on the
> "Form" Sheet are clicked. "<< first record", "<previous record", ">next
> record", "last record>>" .This brings up or populates the previous record
> from the "RoomReservation" Sheet to the "Form" Sheet for viewing
>
> 4) When I click on the the "<< first record" button it goes beyond row7 to
> row 1, showing blanks cells on the "Form" Sheet and not row 7. *What I
> want is, when I click on the "<< first record" button, record on row 7 to
> show on the "Form" Sheet instead of going to row 1 and showing blank cells.
> *
>
> 5) When I click on the the "< previous record" button it goes beyond row
> 7, row 6, row 5 etc, etc, to row 1. *What I want is, when I click on the
> "<previous record" button, view records untill row 7 and not row 6 etc, etc
> to row 1.*
>
> 6) To get to the field of it try clicking these buttons to see how it
> works currently.
>
> Please refeer to the attached file.
>
> I hope I have explained myself clearly and thanks you once again in
> advance for any help that I may recieve.
>
>
>
> On Tue, Jan 17, 2012 at 9:08 AM, dguillett1 <dguille...@gmail.com> wrote:
>
>> Can you re-explain what you want. Perhaps with an example of what it
>> should look like.
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>> *From:* Christopher Kevin <christopher....@gmail.com>
>> *Sent:* Monday, January 16, 2012 4:13 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Previous and Next Buttons on Excel
>> Sheet! Help Please
>>
>> Don,
>>
>> Thank you for the help but it does'nt work.
>>
>> Regards
>>
>> Chris
>>
>> On Tue, Jan 17, 2012 at 4:46 AM, dguillett1 <dguille...@gmail.com> wrote:
>>
>>> Does this help?
>>> .Rows("12:22").Hidden = True
>>>
>>>
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>> *From:* Christopher Kevin <christopher....@gmail.com>
>>> *Sent:* Sunday, January 15, 2012 4:16 PM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet!
>>> Help Please
>>>
>>> Can you experts help me with my problem?
>>>
>>> What I want is:
>>>
>>> When the previous < button is clicked, I want only records up untill row
>>> 7 to show on the Form Sheet as per the attached Room Reservation Sheet.
>>>
>>> And the same should be applied to the go to last record << button. That
>>> is I want row 7 to be the last row and not going back beyond row 7 to row 1.
>>>
>>> How can that be done as per the attached file?
>>>
>>> The that I currently have is included in file.
>>>
>>>
>>> Additional Explaination:
>>>
>>> When I clcik the << and < buttons, column headers and blank rows above
>>> row 7 are also populated on to the Form. How can this be avoided?
>>>
>>> I hope I have explained myself clearly.
>>>
>>> Thank you all you experts in advance for any help that may be provided.
>>>
>>> Chris
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> ------------------------------------------------------------------------------------------------------
>>> To post to this group, send email to excel-macros@googlegroups.com
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> ------------------------------------------------------------------------------------------------------
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> ------------------------------------------------------------------------------------------------------
>> To post to this group, send email to excel-macros@googlegroups.com
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> ------------------------------------------------------------------------------------------------------
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------------------------------------------------------------------------------------------------------
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------------------------------------------------------------------------------------------------------
> To post to this group, send email to excel-macros@googlegroups.com
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
