Saving User Inputted Data From A Worksheet To Another Worksheet And Saving It

Jan 7, 2009

I have created a form in a worksheet which I have added questions too and then locked all cells except the ones where I want the answers in.

I have then added a button to the bottom of the sheet called "Print and Save". This work sheet is called "form"

On a second sheet called "database", I have all the titles of the questions running from a -> k and nother else.

What I want to happen is the user input the information on "form" into the boxes available. Once they have completed the questions, I want them to be able to click on "Print and Save" so that firstly the page "form" prints, and then for all of the answers to be saved in "database" below the titles for each question.

I have had a play, but just don't know where to start. Also, once there is a row of questions below the titles, I don't want it to overwrite information already there, it needs to go onto the next empty row available.

Attached is my excel file.

You will see in the code that I have the code for printing.. I just found this on the net and it seems to work fine for me.

View 9 Replies


Prevent The User From Saving The Data Input From The User Form If Any Of Those Three Fields Is Left Blank

Feb 9, 2010

I have a user form that has a combo box "City" two text boxes one called "Flight" and the other "Date". What I'm trying to do is to prevent the user from saving the data input from the user form if any of those three fields is left blank. The code that I have so far checks all of the required fields, if any are left blank a message notifys which field(s) is left blank and return the focus back to that field. But the rest of code also fires.

What I really need is either to stop the code if any fields are blank and return the focus back to the blank field, the user completes the field(s) and clicks the save again, or better yet, pause the code until all the required fields are completed and then complete the save. (There is actually another 200+ lines of code in this sub, but I deleted it to keep the post a little shorter.)

View 2 Replies View Related

Saving A Worksheet

Mar 23, 2007

I have two worksheets in a spreadsheet but after I use it I want to be able to click a button and just save Sheet2 Alone. Can I do this.

I have this that works but would need to change it up to just save sheet2

Public FilePath As String
Sub SaveAs()
Dim strSaveAsFile As String, fp As String
FilePath = ""
' Change the FilePath to suit
fp = "S:Depot Outgoing"
Call MakeFolders(fp)
Call MakeFolders(Format(Date, "yyyy") & "")
Call MakeFolders(Format(Date, "mmm yyyy") & "")
Call MakeFolders(Format(Date, "mmm dd") & "")

strSaveAsFile = UCase(ActiveSheet.[B8].Value) & ".xls"

ActiveWorkbook.SaveAs FilePath & strSaveAsFile, xlWorkbookNormal
FilePath = ""

End Sub

View 9 Replies View Related

Saving One Worksheet

Mar 28, 2007

I have 2 sheets in a spreadsheet I would like to Save Sheet2 ("Packing Slip") ONLY!
If I can I am trying something like this.

Public FilePath As String
Sub SaveAs()
Dim strSaveAsFile As String, fp As String

FilePath = ""
' Change the FilePath to suit
fp = "S:Projects"
Call MakeFolders(fp)
Call MakeFolders("PCAR " & Format(Date, "yyyy") & "")
Call MakeFolders("PCAR " & Format(Date, "yyyy") & " OUTGOING" & "")
Call MakeFolders(UCase(Format(Date, "mmm yyyy") & "")).........................

View 9 Replies View Related

Saving User Based Data?

Jan 1, 2014

I am working on a project in which I used a formula and created a kind of a software.what I need to do is that after my user enters certain data it is sent to a worksheet(as directed).now I want that data to remain saved there even when I am changing the inputs in the formula. what is happening is that my previous data is getting erased when I enter new variables to the formula .

View 1 Replies View Related


Apr 20, 2009

Saving WORKSHEET file. I'm using this code:

View 4 Replies View Related

VBA Not Saving Complete Worksheet?

Feb 8, 2013

The idea is that a button on the worksheet 'Sample Info & Results' runs the macro which copies the worksheet to a new file with the name specified in the cell B3 and saves it as a csv format with ";" as the separator. For the most part it is working with the exception that the export stops at row 6 for some reason I dont understand. The code is not mine (credit to T.Thielmans on stackoverflow). code for 1) referencing a folder location within the original file to use as a standard location to save the csv file and/or 2) removing hidden columns.

Public Sub ExportToCSVFile(FName As String, Sep As String, SelectionOnly As Boolean, AppendData As Boolean)
Dim WholeLine As String


View 3 Replies View Related

Saving A Worksheet Or Wookbook

Apr 26, 2006

I have a sheet that I want personnel to enter in data into certain cells.

The problem Im having is that people are saving the workbook with different names then what it is from the data they entered.

I want EXCEL to save the excel sheet as it is typed in one of the cells in the workbook.

Example: the information typed in cell A1 is " Black Dog ".

I want the excel workbook they are currently working on to promt the "Save As" box to save as " Black Dog " when they are done entering data into that cell.

Is there a Macro or something out there that would bring up the "Save As" box to save the workbook or worksheet?

View 7 Replies View Related

Saving A Worksheet As A File

Oct 24, 2006

I have a workbook which utilizes 2 worksheets to fill a third. I would like a macro to be able to save JUST that worksheet, and not the other two. I thought there was a checkbox allowing you to "save selected" only, but I'm either dreaming, or it was in a previous version of Excel (I know use Excel 2000).

View 9 Replies View Related

Saving Worksheet As PDF Using Vb On Click Button?

Jul 10, 2014

I've been looking for a way to save a worksheet as a PDF document and place it in a folder in Documents.

View 4 Replies View Related

Worksheet Not Saving Array Values

Apr 24, 2014

Below is the syntex I am using in the array... and the source file.. when opened will calculate the values. The problem arises when I close the source file and values return to this " #Value". My entire frontend file is nothing but arrays and links compiling data from multiple sources and everything works except cells that have the below array in them.

why my cell values will not save upon saving and closing both my frontend file and source file?

[MIS_Incoming.xls]Weekly_Inc_Overview!$D$2:$D$80,"First Chargeback")+SUMIFS([MIS_Incoming.xls]Weekly_Inc_Overview!$E$2:$E$80,

[Code] ........

View 3 Replies View Related

During Saving Worksheet Cells Loosing Links?

Jul 4, 2014

When i save the worksheet cells are loosing links to other cells. what is even more surprising it happens only for 6 cells in 6 sheets.

scheme of links
Basic data

On the sheets P1-P6, each cell A1 has a link to Basic data.

View 2 Replies View Related

VBA Saving Copy Of Single Worksheet To Different Folder?

Oct 26, 2012

I currently have a application that people fill out on a userform. When they click on a command button at the end it puts all that information on a sheet i made and then we print it off. My objective is when it saves it to the sheet it also save a copy of that paticular sheet in a seperate location such as H:/applications. Also the copy should be renamed to the information thats in a specific cell Such as j4 the have this text added after that "Application"..

View 4 Replies View Related

Macro Close A Worksheet Without Saving And Without Confirmation

Dec 17, 2002

I am new to EXCEL and wanted to know if you can have excel startup running a macro and also if you can have a macro close a worksheet without saving and without confirmation. I created the basic macro of what I want to do. I just want it to be able to run unattended. Is this possible with EXCEL?

View 9 Replies View Related

Saving Excel Documnets ... Open First Worksheet Every Time

Apr 17, 2009

I have a workbook with several worsheets in it. I wish to have the first worksheet as a list that will be hyperlinked to the other worksheets within the documant.

Is it possible to save the workbook so that it will open at the first worksheet every time irrespective of what worksheet you were on prior to clicking save.

View 7 Replies View Related

Saving A Worksheet As A Asterisk Delimited Text File?

Sep 19, 2013

I am trying to save a worksheet as a txt file. The worksheet has a range of data with a variable amount of rows in column A only. It generally will look like:


where each row of data is in a single cell.Whenever I save it, however, it adds extra tab deliminations in each row after the data, and it adds rows with no data (sometimes just 1, sometimes many).

I am positive that no cells in columns B-n have data in them (even just a space) and no rows after the last intended have data.

Why are these extra rows and columns being inserted? How can I save a txt file that literally has no other spaces or rows or deliminations other than what's intended?

View 2 Replies View Related

Saving Worksheet In Html Format Office 2007

Jan 20, 2008

I have been using code to save a collection of my reports in html format that has work very well until I was forced into using Vista and office 2007. Here is a snippet of the code that no longer works - at least I suspect this is the main problem.

View 4 Replies View Related

Deleting Multiple Worksheets And Saving Active Worksheet

Aug 3, 2007

I am trying to find a easy way to delete multiple worksheets in a workbook and then saving the workbook based on the tab name of the worksheet.

View 9 Replies View Related

Excel 2013 :: Saving Large Multiple Worksheet File

Aug 11, 2014

I have an Excel file that's updated monthly. when it does save its around 16mb and can take up to 12 hours to save, and sometimes just doesn't.

I have tried saving as binary, I have made sure exact size of area to be saved is required, I have tried save with no calculations.

Basically the only reason I need to save it is so that another analysis spreadsheet can pull data from it. The file is heavily formatted, charts, vlookup tables etc, none of which is needed when analysis spreadsheet links to it.

View 1 Replies View Related

Excel 2007 :: Saving Worksheet As New XLS File Without Compatibility Checker

Apr 24, 2013

We are using Excel 2007.

I have a macro enabled spreadsheet and I need to save one sheet into a new file that is in xls format. I can do that --- is there anyway to suppress the Compatibility Checker box to make it that much easier?

The new file will not have macros as will just be a data in rows and columns so compatibility. Interesting is the compatibility checker box says there are links to the original spreadsheet, but I can't find them in the connections menu.

View 2 Replies View Related

Stopping User Saving Unless Condition Met.

Mar 6, 2008

I am looking to stop the user saving the sheet if certain fields are not complete.

The sheet has headers on line 4 and runs from A4 to M500

In the M cells there is a counta function to check the records are complete.

M4:M500 shows either

Complete - All records comlpete
Incomplete - something missing
Blank - nothing entered yet.

What i want to do is, if one of the cells in M shows incomplete not allow them to save the sheet until its complete.

I tried the folowing (was my attempt to modify another post)

View 10 Replies View Related

Preventing A User From Saving A Workbook

Apr 10, 2008

if it is possible to prevent a workbook from being saved other than by a macro (So no saves on Ctrl + S or File Saves). Basically, I want to allow users to use a template that I have set up, but I do not want to allow them to be able to save the document.

View 9 Replies View Related

Saving A File Without Saving Macro

Jan 30, 2003

I have a spreadsheet that imports data, manipulates it then deletes 2 of the sheets then saves the file under a different name to the network. Is there any way to save this new worksheet without it storing the macros - so when the user open it, only the data is there and they get no prompt to enable macros?

View 6 Replies View Related

Template Excel File - Stop User From Saving

Oct 3, 2008

I have a template excel file that is loaded with macros. When the file is opened, a userform opens and the user makes several different selections. Based on the selections, the excel file is populated with information and pictures. I want to make sure that the user does not accidentally save over the template file when he/she is finished with the document.

My original solution was: when the user opened the excel file, it would automatically save under a different name in a temporary location. This would stop the user from being able to overwrite the source file. The users were not happy because the excel file is very large and takes a long time to save.

on another method to stop the user from overwriting the source file? using code? or another method?

View 9 Replies View Related

User To Select Variable Folder For Saving Files

Jun 11, 2009

I would like my macro to prompt the user to select a folder for files to be either opened from or saved to during the running of my macro.

In fact, I need them to select two folders, one for this month and the other for last month.

I think I need to set the two folders as a variable but being fairly new to vba I'm not quite sure how to do this.

View 9 Replies View Related

User Forms Saving Items Entered To Memory

Feb 16, 2010

Is there a way to save items into memory to be recalled in userforms.

Let's assume that I have a userform called UserForm1 and three textboxes named TextBox1, TextBox2 and TextBox3.

View 9 Replies View Related

Formatting Worksheet: Re-adjust The Worksheet To Make It More User Friendly Based On Number Of Rows In Current Sheet

Oct 14, 2008

I have a worksheet with 30,000 rows. But sometimes even if I have fewer records in this worksheet(lets say 1000) worksheet shows the same 30,000 rows.And its annoying when you try to navigate using vertical scroll bar. Is there any option to re-adjust the worksheet to make it more user friendly based on number of rows in current sheet.

View 2 Replies View Related

User Form Data To New Record On Worksheet

Mar 22, 2009

VBA code to get userform input from form to "Data" worksheet. Data starts at columns A3..AG3. I need the code for the "Input" button to put Month, Date, Type, Comments under their corresponding columns and the "Amount" to go under the appropriate column that is selected by the Option Button. I've included a picture with in "red" comments.

View 8 Replies View Related

Saving Document After Every Data Entry?

Aug 20, 2013

How to set up an excel sheet to automatically save data after every data entry? Or maybe after a specified time period?

View 1 Replies View Related

Saving Userform Data To Different Workbook?

Oct 29, 2009

Is it possible to have a userform open in a workbook and when the data from the form is saved, save it to a completely different workbook. If so, will that other workbook need to be open for the userform data to be saved?

View 5 Replies View Related

Copyrights 2005-15, All rights reserved