Pasting Formulas in a formatted spreatsheet

**donxkey** · 12-15-2009, 10:11 AM

I have been asked by my manager to make new shelf labels for all our stationery products for the VAT change in the new year. I'm sure I can get excel to help me make the task quicker but i'm just having trouble with pasting the formulas into the label template that I have to use, I was wondering if anyone could tell me why and if it is possible to do with the way I set the document out.

Attached is what I have so far.

Please tell me if there is a simpler way of doing this. The data sheet is the item description and the old price. The labels sheet i need to be able to print off in that format so i can cut it up and use the labels on our shelves. The formula for the VAT change is on the labels sheet, it works on the old price on the data sheet. I want to be able to quickly apply the formulas and format of the labels to more cells in the sheet so i can print off multiple pages of labels.

I have tried just copying the current formatted cells (A2 to C29) which I have seperatley typed the formulas into (takes ages) and pasting them beneath that. It doesnt continue the formula though. Instead of the next label cells formula carrying on and being Data!A43 it become Data!A29. Perhaps what I want to do is not even possible!

I would appreciate any help

thanks
Clare

**MickG** · 12-15-2009, 11:08 AM

Hi, See sheet Label (2) with CommandButton.
This code can be used in any sheet to update "Data" Prices Based on Sheet "Data" columns "A & B", and will Insert new prices into your sheet as you have formatted.
Regards Mick