Hi ExcelForum,

Firstly, what an amazing forum, I think I have learnt more about macros in this one day than I ever have! But please be aware, I am simply a copier and paster when it comes to macros. I have been using these forums for the last couple of months to learn more about macros as the need has been arising within my career. I am very grateful for the resources here.

I will try and explain my situation and query as best as I can;

My current goal;

- To create a tool in excel that allows a user to edit some data (mostly columns of numbers with one column of text and two dates) and then upload this as a CSV into an application.

My current situation;

- Sheet 1 contains the edit tool and macro buttons
- Sheet 2 is blank and its cells are pointing to sheet 1 fields using an IF statement to blank out cells with no data
- I have a macro to create a CSV file (i found this macro on this forum and made some tweaks to prompt for input of file name etc)

The issue;
- When I upload the CSV file to the application, it seems to be reading hundreds of additional lines that did not contain data although in the tool I created, there were formulas in these columns looking for data

What I did to try and fix the issue;
- So I assumed that it must have been something to do with the fact I had a formula in certain cells before exporting as a csv. So I created another macro that basically used a new column to check if the row was populated with data and then cleared contents of rows that were not. This still did not work. (this also meant that rows with data had the first column with formulas that was returning "")

So does anyone have any idea what could be going wrong? Is there something I should do for the generation of the CSV file. Most of the time the first column of data will need to be blank.

Any help would be much appreciated.

Cheers