Locking first cell for macro to copy into

**Wazations** · 09-01-2012, 04:03 PM

Hi,
I'm having a problem with the following formula. In that I cannot get it to do what I need it to, where I need it

Please Login or Register  to view this content.

The formula itself is working, my issue is that I cannot get it to enter the data into the cells defined by the red selection. I'm trying to get it to start filling the formula in from cell A6, but it keeps starting from A1 even when I put $A$6. same with the B column. I don't know what this is even called so if it's been asked before then can someone point me in the right direction?

Thanks
Waz.
(p.s I know the rest of the formula works because it gives me the values i need)

**TMS** · 09-01-2012, 05:19 PM

You're looking in column D on Sheet Card for the last row.

Works fine for me. If I have 1 to 16 in cells D1 to D16 on the Card sheet, it puts the formulae in rows 6 to 16 on the CHECK sheet.

Regards, TMS

**Wazations** · 09-02-2012, 10:29 AM

Oh, well what I am wanting it to do is, for example with your example it only puts it into the cells 6 to 16, I am wanting it to put the formula FROM cell 6 to the 16th cell below for example. basically so it starts putting the values in from 6 down to the same number

**TMS** · 09-02-2012, 10:45 AM

Then use CardLastRow+5 instead of just CardLastRow.

Regards, TMS

**Wazations** · 09-02-2012, 11:27 AM

Yes, that worked a treat

Thanks for the help, I know it may have seemed an easy question but I have no training at all with macro's, just what I've tested and looked up :P

Thanks a lot
Waz

**Cutter** · 09-02-2012, 12:30 PM

@ Wazations

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.