Copy only the formulas in a column that has values and formulas

[slight]

I prepare monthly financial statements in Excel using VLOOKUP to copy the month's results from a file that I downloaded to a text file. There are approximately 600 rows of values and subtotals in a column.
After using VLOOKUP I convert the current month's cell contents to values. I have to each section of the P & L separately because of the subtotals.
I would save a lot of time if I could copy the formulas in last month's column to this month's column all at once.
I am not proficient enough in Excel to use VBA.
Is there a way that I can do this?
Attached is a sample file.

 

[Bhawani]

so slight what you want you want values only or formulas only or both of them
1. For Values - you need to copy cells then need to paste them with using paste special -> values only
2. For Formulas - you need to more explain whether the months file are in same workbook or different.
attached file does not containg any vlookup function.

Regards,

 

[json]

i'm not following what you're trying to accomplish... can you give some more details on what data you're using and the end result? maybe like a play by play?

 

[NARAYANK991]

Hi ,

I think you are going about it in a somewhat complicated way.

Can you not have your tab named Book 1 showing all the 12 months of the year with formulae in all the cells for all the months ? Have another sheet labelled RawData , where you will copy each month's results from your text file ; each month will have its own column , so that the RawData tab will also have input data for all 12 months.

In case of months whose data is not yet available , the formulae on the Book 1 tab may return either a zero value or an error value , I do not know how your formulae are written. If you wish to suppress zeroes , use the appropriate cell format ; if you wish to suppress error values , use the IFERROR function around each of your formulae.

Either way , once your Book 1 tab is set up correctly , you do not need to do anything else with it.

Narayan

 

[slight]

so slight what you want you want values only or formulas only or both of them
1. For Values - you need to copy cells then need to paste them with using paste special -> values only
2. For Formulas - you need to more explain whether the months file are in same workbook or different.
attached file does not containg any vlookup function.

Regards,

Thank you for the reply.

 

[slight]

i'm not following what you're trying to accomplish... can you give some more details on what data you're using and the end result? maybe like a play by play?

I guess my question was poorly detailed.
Thanks for the reply.

 

[slight]

Hi ,

I think you are going about it in a somewhat complicated way.

Can you not have your tab named Book 1 showing all the 12 months of the year with formulae in all the cells for all the months ? Have another sheet labelled RawData , where you will copy each month's results from your text file ; each month will have its own column , so that the RawData tab will also have input data for all 12 months.

In case of months whose data is not yet available , the formulae on the Book 1 tab may return either a zero value or an error value , I do not know how your formulae are written. If you wish to suppress zeroes , use the appropriate cell format ; if you wish to suppress error values , use the IFERROR function around each of your formulae.

Either way , once your Book 1 tab is set up correctly , you do not need to do anything else with it.

Narayan

I did not explain myself very well. I want my spreadsheet to not have any cells with links.
Thank you for taking the time to answer my question.

 

[json]

Still need some more info.... i think you're showing us the 'completed' version that no longer has any formulas.... which is why its confusing to us who are not familiar with the steps that have been taken/needed to get to the current state of the spreadsheet.

is it possible to provide an example of the data BEFORE you do anything to it? in your first post you mentioned using the VLOOKUP but i dont see any cells with that formula...