Allowing paste but not over specific cells/formulas

[ickle1999]

Hi,

I have created a spreadsheet A with a number of headings and within this spreadsheet I have created some formulas (vlookup & concatenate etc.).

The base data is in spreadsheet B that is designed to replicate the layout in spreadsheet A. Within spreadsheet B some columns have been left blank where the formulas are located in spreadsheet A.

I need the base data in spreadsheet B copied into spreadsheet A but without overwriting the formulas that have been created. The formulas are required for bringing in information from different sheets within spreadsheet A.

Therefore, I need to paste data from spreadsheet B into A without overwriting the formulas in the required cells – Is this possible?

Thanks in advance
Ickle

[Keebellah]

Hi, welcome to the forum.
Without the actual sheets it's difficult to tell.
You would probably need to write some code that reads each cell in the source and paste it only into cells that do not contain formulas.
There is no way to just say paste and skip formula cells.
unless the layout is identical so that the cells to be copied are always non-equal to the formula cells in the target then you could use SpecialCells(XlCellTypeConstants) to copy and paste
I suggest you lookup[ u(Google) using SpecialCells

[ickle1999]

Thanks Keebellah.

I will take a look at SpecialCells

Both spreadsheets will have exactly the same layout its just that the information will be being populated in both. Two different teams will be populating their specific data and then B will be pasted into A to ensure that we have one fully populated spreadsheet. Therefore, B cannot over copy the information already populated in A.

Ickle

[Keebellah]

Hi Ickle, if the layout is the same and the formulas are in the same cells then using the special cells and the constants type will only take those cells that do NOT have formulas.
But if you also say that two different users will use this then you will have to write the vba code so that only the empty cells will be filled and not overwrite existing data.
This will take some thinking and writing code that will answer to specific conditions.
But that is something only you can decide since we don't have anything to go on.