Over 1 million tech questions and answers.

Update selected data Automatically

Q: Update selected data Automatically

Hello All,

I have a doubt on excel, please share your ideas for the below mentioned query:
First of all, I have created New Worksheet & saved as "MAIN" in different location. I have the sub-ordinates of 15 members, who work on their excel sheet with different location.

Here, i would like to copy some selected contents or copy several columns from their worksheet to the "MAIN" worksheet. I used to do it manually. Now, my question is that is there any other way to sort this automatically?

I had tried by applying some formulas, but it worked only for a single person. But i required for all 15 members data to be copied at once.

Thanks,
Kit

RELEVANCY SCORE 200
Preferred Solution: Update selected data Automatically

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Update selected data Automatically

Read other 11 answers
RELEVANCY SCORE 69.6

I am trying to have a drop down box in a form determining in which table a new record will be added.
Here is a scenario:
I have three categories of inventory in our stock divided into three tables: “Office Equipment List”, “Medical Equipment List”, “Audio Materials List”. And the fields for each one of them are:
Table “Office Equipment List”: “Office equipment” field, “Allocated to” field, “Value” field

Table “Medical Equipment List”: ”Medical Equipment” field, “Allocated to” field, “Value” field

Table “Audio Materials List”: “Audio materials” field, “Allocated to” field, “Value” field

I have a form labeled “MAIN INVENTORY” with a drop down box storing all three of these categories. If I select “Medical Equipment” field from the drop down box, all the other fields in the form will be reflected on the “Medical Equipment List” table. If I select “Audio Materials” field on the drop down box, all the other fields that I fill out will be reflected on the “Audio Materials List” table. And it’s the same for the “Office Equipment List”.
Can anyone help me figure this out?
Thank you in advance!
 

Read other answers
RELEVANCY SCORE 69.2

I have a worksheet in which name is “Master” sheet where there have 26 columns of data for our office employees. In the Z column I have mentioned only status of the employee i.e. Present / Resigned & I have given formula of data validation. In this file I have another 2 sheets which is “Present” & another is “Resigned”. My query is when I will select “Present” from Z column of Master sheet only 15 columns will be copied (i.e. A to O) without header & paste it in the Present sheet in the below available row. And when I will select “Resigned” , data will be copied of A to J column & paste it in the Resigned sheet. Last it will check the duplicates & delete it form both sheets.
 

A:Data Update in Next Available Row in the Selected Sheet

Hi there, welcome to the board!

I will suggest you have one sheet for input and then (possibly 2 sheets for) an output. Sounds like a PivotTable for each output desired. You shouldn't be deleting any data, it's generally bad habits and throws red flags for me. Can you set this up as a PivotTable? I'm not sure how familiar you are with Excel, or even what version you're working with. While we can do this in a macro, I'm not sure we should.
 

Read other 1 answers
RELEVANCY SCORE 57.2

I've got a laptop running Win2k SP3. It has one hardware profile that seems to work OK, docked or undocked.

For the most part.

Now, I want to disable a piece of hardware only when the system is docked. I've created a new profile by copying the existing one, rebooting, manually selecting the "docked" profile, then modifing the device properties.

This works, but I don't like the part about manually selecting the profile when I boot. Additionally, I'd like Win2k to automatically switch profiles if I suspend and undock (or dock) the system - without rebooting. This doesn't seem to happen.

Should this work as I described? Is this a pipe dream? Should I resign myself to always rebooting the system after changing docking status?

Thanks.
 

Read other answers
RELEVANCY SCORE 56

I am running Win 7 Pro x64.

I use SeaMonkey 2.32.1 as my browser.

User agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:35.0) Gecko/20100101 Firefox/35.0 SeaMonkey/2.32.1
Build identifier: 20150204202218

When I want to select and copy some text from a search hit, I find that the system 'thinks it knows better" and it starts jumping backwards and forwards in an attempt to save me a little work.

Is this behavior controlled by the OS or by the browser?

I would like to turn this 'feature' off; I find it counterproductive. Where do I start?

thanks,

baumgrenze

A:Text Automatically Selected While Browing - How to Turn This Off

Hello baumgrenze,








  
Quote: Originally Posted by baumgrenze


When I want to select and copy some text from a search hit, I find that the system 'thinks it knows better" and it starts jumping backwards and forwards in an attempt to save me a little work.


What exactly 'jumps backwards and forwards', is it the mouse or the webpage?

I know Google and some other Search Engines have a function in javascript where if you use the 'Up' or 'Down' arrow-key, it will select the next or previous search result.
Google's blue arrows: I hate it, turn it off! - State of Digital

For Google, the only way i know to disable it would be to disable 'Instant Search' or Javascript.
In my opinion though, it is a pretty useful feature if i do not have a mouse in hand.

Have a good day ^^.

Read other 3 answers
RELEVANCY SCORE 55.2

When I start my computer last icon of the desktop is automatically selected.
When i click on other icons only the last icon is opened.
I can open the icons if i press the TAB button and refresh.
But it is limited to some time only.
Also webpages are scrolled down automatically till the end.It stops if I press TAB. But after some time it stars again.

A:When I start my computer last icon of the desktop is automatically selected

You refer to "the last icon", does that mean the icon in the last position on the screen, the last icon to load; if you have, for instance, 12 icons on your screen, always the twelfth in the array of icons? If it always happens with the icon in the same screen position whatever it may be, then it may not be related to the icon's function but to how the GUI selects it. Presumably most of the icons are shortcuts, have you tried deleting some? Could that irritating "You have unused icons on your desktop" pop-up be involved?

Read other 3 answers
RELEVANCY SCORE 55.2

When I start my computer last icon of the desktop is automatically selected.
When i click on other icons only the last icon is opened.
But it is limited to some time only.
Also webpages are scrolled down automatically till the end.It stops if I press TAB. But after some time it stars again. i am using DELL INSPIRON 5010.

A:When I start my computer last icon of the desktop is automatically selected.

Hi preet7,

Please elaborate more on your issue. Did this problem happened all of a sudden? Was your computer working last night but not today? You said when your computer boots to windows, the last icon is automatically selected? May I ask, what is that program? One thing, try scanning your computer for any viruses/spyware. Please provide an update when you can, thank you.

Read other 3 answers
RELEVANCY SCORE 55.2

Hi guys,

This is really annoying problem I'm facing for many days. If a select any text from a editor like notepad,word,etc. It automatically copy the text without any copy operation by me like ctrl+c or mouse copy. I need to restart my os to make it normal again.

It happens randomly. this a problem in clipboard for sure. For example if I select text from notepad, I can paste it to word, ect. I don't know is it a feature from microsof. I want to disable this forever. How to get rid of this issue. Please help me.
 

A:clipboard copy automatically while any text selected from editor.

Read other 7 answers
RELEVANCY SCORE 55.2

When I start my computer last icon of the desktop is automatically selected.
When i click on other icons only the last icon is opened.
I can open the icons if i press the TAB button and refresh.
But it is limited to some time only.
Also webpages are scrolled down automatically till the end.It stops if I press TAB. But after some time it stars again.

A:When I start my computer last icon of the desktop is automatically selected.

The scroll problem sounds like the mouse is causing it and might affect the icon choosing also. To be sure before going into other solutions, see what happens with a different mouse.

Read other 12 answers
RELEVANCY SCORE 54

When you enter the login screen, one of the user account options is pre-highlighted so that if you simply press "enter" instead of selecting one with the mouse or arrow keys, it'll attempt to log you into that account. I've the need recently to create a standard user account, which for some incredibly frustrating reason is always pre-selected instead of my administrator account (the one I use). I have no idea how to change this so that the administrator account is the one pre-selected.

Yea this is a stupid thing to complain about. But I've gotten used to logging in one way, and it's super annoying every time I forget and try the old way. Especially if I'm not in the best state of mind lol.

Oh, and for some reason creating a Guest account doesn't do this. Admin keeps priority. But Standard users are evidently more important than the admin >.>

A:Changing the automatically selected user account on login screen - Windows 7

Does my description of the problem not make sense, or is there just not a solution?

Read other 4 answers
RELEVANCY SCORE 51.6

My wireless internet was slow, so I tried to improve it by changing the wireless channel from 11 to 1 and the mode from B /N/ G to just N.

Now when I try to connect it fails, I run diagnostics and I get the error message saying that the selected data rate is not correct. And that my wireless settings for the network adapter on this computer don't match the settings of the network.

I am currently on my phone which has connected perfectly well.

Yes I have tried turning both my laptop and the router off and on again.
 

A:Solved: Error: The selected data rate is not correct

...I changed it back to B/ N/ G on my phone and it worked. Oops
 

Read other 1 answers
RELEVANCY SCORE 51.2

Hey everyone,

I was wondering if anybody on these forums could help me with the below task?

I run a backup program that generates email reports to a subfolder in my Outlook 2010 every 6-8 hours to tell me the status of every backup job that I have set up and have running. The email details the job name, the job start time, and the job status (running, completed successfully, failed, missed, cancelled etc).

At the moment, I sift through each and every one of these emails (I have over 100 backup jobs per day) and enter the relevant data manually into my excel spreadsheet. The spreadsheet looks like the following:

Job name Monday 1st Oct Tuesday 2nd Oct Wednesday 3rd Oct Thursday 4th Oct
Job_xxx SUCCESS SUCCESS FAILED FAILED
Job_yyy SUCCESS SUCCESS SUCCESS RUNNING
Job_zzz MISSED MISSED CANCELLED SUCCESS

What I’d like is to automate this process, so that each day, perhaps every 4 hours, a script would run that would search for certain values within each email I receive and update the excel sheet accordingly.

Example:

- Monday 1st Oct, 10am – email comes into inbox with subject/body containing “Job_xxx has started “ >>>> update Excel sheet to record RUNNING under column ‘Monday’ in row titled 'job_xxx'
- Monday 1st Oct, 1pm – email comes into inbox with subject/body containing “job_xxx completed successfully” >>>> update Excel sheet to record SUCCESS, ... Read more

Read other answers
RELEVANCY SCORE 51.2

Hi there
sincerely hoping & wondering whether someone out here could help me by offering me your solution or suggestion ?

My situation is as follows:
In my worksheet there is about 600 cells scattered all over the sheet that are to represent different monetary value figures, that I have used NAME MANAGER to define as MONEDATA1, MONEDATA2, and MONEDATA3 (each holding around 200 cells, which is the approx.limit allowed by NAME MANAGER for Excel 2010). Thing is, my work revolves around dealing with 12 different countries of currencies, and so all these monetary cells, in CURRENCY format, thus need to be 1 out of 12 different currencies with respective currency signs, at any one time I do some calculation. So, they must convert into 1 of those 12 currencies, each time determined by a selection from a single dropdown list of 12 currencies located at the top of the worksheet in one particular cell I data validated, which is $C$6.

Now, I just need the worksheet to convert all the 3 groups MONEDATA1, MONEDATA2 and 3 simultaneously, instantly when 1 of the 12 currencies is chosen in $C$6, by using a VBA code. Is there a best way to resolve this need ?

Could you help me with the above problem ? Thanks in anticipation and advance ! Greatly appreciated any help.
cheers & have a nice day there,
Jason.
 

A:Excel data validation and executing a code based on selected value

 

Read other 1 answers
RELEVANCY SCORE 50.4

Hello all

When executing Windows Update, I experienced that one important update is not automatically selected to download and install.


I like to understand why this is?

Also I like to understand if I should always install all important updates, even the ones not by default selected?

In this example, the not selected update refers to MS09-054 security update. Is this a manual installed security update?
Does it not apply to me?

Thanks a lot in advance!

zx81

A:Windows Update, important update not selected

Not all users experience the issue that this update resolves. MS is providing you the oportunity to use the "If it ain't broke, don't fix it" logic.

I applied the update even though I have no evidence that I need it. Yet.

Some updates will adversely affect some users. Not applying updates may adversely affect you.

What can you do? My advice - apply all updates. Unless you have a good reason not to.

Read other 7 answers
RELEVANCY SCORE 49.6

Hi,

I've been searching for most parts of the net and the forums here and did install/uninstall/restore my notepad, paint and wordpad but nothing seems to work.

When these files are opened, nothing seems to be a problem. But whenever you attempt to save by Ctrl+S, or the by clicking File>Save or File>Save As the program automatically closes. This has been a consistent behavior for the 3 softwares.

I'm using Windows XP 64 bit OS and had no error messages of any sort except that these programs just close themselves when a save attempt is done.

I did virus and malware scans by Avast, ESET Nod & Kaspersky and nothing was detected.

Reinstalling isn't an option for me now as I don't have any optical drive... besides, this may be very hard for me but I'm willing to suffer for the sake of learning.

I'd really appreciate your inputs on this matter.
Thanks for all ideas and help ahead!
 

A:Notepad, Wordpad, Paint automatically closes whenever save or save as is selected.

How did you uninstall/reinstall the programs without the CD? They're part of the system.
 

Read other 2 answers
RELEVANCY SCORE 49.6

HiI just found something strange (?) - if I right click IE8 shortcut and select "Run As...", leave option Protect my computer and data from unauthorized program activity checked and click OK IE8 won't start... there is no error (not even in the event viewer), it just doesn't work. I checked it on 2 different computers, one recently formatted. Is that normal? If yes, how can I browse the web securely from the administrator account? Thx

A:IE8 doesn't work with "Protect my computer and data from unauthorized program activity" option selected (from Run a...

That does seem to be Microsoft's idea of maximum protection. It isn't necessary to access the net as an administrator. It is safer to have a separate user account as it limits the damage caused by malware. Using the smart screen filter and in private browsing helps. Firefox with NoScript and the HTTPS Everywhere add-on is safer than Internet Explorer. There is no guaranteed security.

Read other 1 answers
RELEVANCY SCORE 48

Hello,

I have two spreadsheets saved as seperate files with different names. One is sheet is called parcels.xls. The other is Parcels.Sales.Update.xls.

parcels.xls is a master record of all properties in the county I live in. Parcels.Sales.Update.xls is a record of updated sales data for the properties in parcels.xls.

parcels.xls has a unique PIN (property identifier number) for every property on the sheet. Parcels.Sales.Update.xls lists only PIN's that have recently sold. Both sheets have a column called SALES_YY (last date the proerty sold) and a column called SALE_PRICE.

I want to take all of the PIN's from the Parcels.Sales.Update.xls sheet that match the PIN's in the parcels.xls sheet and update the SALES_YY and SALE_PRICE columns.

Can anyone help me with this? Be easy on me, I am not a speadsheet expert.

Thanks,

Rob Caldwell
Savannah, Ga
 

A:Update selected columns from one spreadsheet to another

Read other 9 answers
RELEVANCY SCORE 48

IE freezes when windows update is selected.
 

A:ie freezes when windows update is selected

Read other 10 answers
RELEVANCY SCORE 48

Why are some of the "Important" Windows 8 updates not automatically selected for installation?

A:Windows 8 update not selected to install

Originally Posted by JeffL


Why are some of the "Important" Windows 8 updates not automatically selected for installation?






Hello there!

I think it's because it's Malicious Software Removal Tool for Windows 8 which is important but not for everyone.

Read other 4 answers
RELEVANCY SCORE 46.4

Hello!

I am fairly new to Access 2010, but can usually find answers to most of my questions. I have hit a wall here, though:

I have a combo box in a form that finds a specific record within a query. This query then fills in all the text boxes within the form, which can then be printed from an identical report.

There is one specific record that when selected from the combo box seems to bypass all the IF statements in my code. I have 10 or so records that have IF statements such that if the carton number = "blah", then label123 will be visible etc. All of the products update the form correctly except for this one.

However, even if the form does not look as it should, if my "print_record" button is clicked, the report with the same underlying coding shows up correctly. Similarly, if the form is unloaded on this "rebel" record, when reopened it is formatted correctly as well. Unless I choose another record from the combo box, and then choose the "bad" record again.

The only thing I can think of that is different about this record, is that the field entry in the IF statement necessary for this record includes an asterisk, i.e. 123-4567*. Also, the product name for this record includes quotations, i.e. Brand "Identifier" Type. Though this product name is not used anwhere in the VBA code.

Please help!
 

A:Solved: Specific record selected from combobox won't update form

Read other 6 answers
RELEVANCY SCORE 46.4

Hi.

I'm a beginner when it comes to VB Script and so I am struggling to work this out. I basically have a worksheet that contains information about different staff members. The sheet is set up so that column A (from row 8 on) is their name and columns B to L (also from row 8 on) are other staff attributes. Due to several reasons, there is more than one listing for each staff member (up to 40). The database is supposed to be there so that any staff member can come in and look up their information (or that of any other staff member). However, with so many listings and so many staff members, it becomes an unmanageable database. I could just create filters so that staff members could simply filter out other employees; however, this would create issues. Instead, I have created a cell above the table (say C2) where staff members can enter their name via means of a data validation list (which is linked to a list of staff members on another sheet). I would then like all rows in the table to hide except for those where the name in column A = C2.

I have searched this on the net and I keep seeing similar responses that all say it's hard when there is data validation / formulas involved. Is there a way this can be done?

Cheers
 

Read other answers
RELEVANCY SCORE 45.6

Hi All,
I'm trying to use Message Analyzer to show captured traffic.
I see a difference with Wireshark about Base64 messages; i.e. if you analyze an http traffic with basic authentication, Wireshark show the original Base64 data and then the decoded text data.
It is possible to do the same with Message Analyzer?
Thanks

Read other answers
RELEVANCY SCORE 45.6

I am an absolute begineer in MS Access. Will try to put my question as simply n clearly as possible.

I have designed a database to keep history of our company's projects. The 'Master Project History Table' contains fields including 'Project Ref', 'Project Title', 'Project Budget' and 'Project Year'. The users are expected to populate the table through 'Master Project HistoryForm'.

The key field is set as 'Project Ref'.

Some of the projects are combined with each other and to display this info, 'Master Project History Form' also has the fields 'Project Ref-1', 'Project Title-1', 'Project Budget-1' and 'Project Year-1'.

I am loking for a code for the ('On Update' event) that will fetch and display data in 'Project Title-1', 'Project Budget-1' and 'Project Year-1' fields when 'Project Ref-1' is updated. Please note that all this info is coming from the same 'Master Project History Table'.

My IT guys told me to use a code with variable for each field that goes something like this (to update Project Title-1 field):

Dim varX As Variant

varX = DLookup("[Project Title]" , "Master Project History Table" , "[Project Ref]=" & Forms![Master Project History Form]![Project Ref-1])

Me![Project Title-1] = varX

And then repeat for each other field by defining new vari... Read more

A:MS Access: Updating Data In One Field Should Update Data In All Relevant Fields

Read other 14 answers
RELEVANCY SCORE 45.2

Hiya gang,
I need to know where I went wrong and for someone to point me in the right direction for a plausible solution.
Here is my task at hand:
Our database crashed and we lost data. I don't want to loose the data we have already inputted since the crash; however, there is missing data.
I loaded up the last best known back up of our database to recover the lost data.
So far so good.
I have done the following below:
Exported field from one db1_be.mdb file
Imported field to new db1_be.mdb file
Run Query to compare data and fill any missing fields with corresponding data

In essence, I am attempting to replace data from a compare data field query in access 2007.

Listed below are the web links I used to create the process above:
Export a database object to another Access database
http://office.microsoft.com/en-us/a...t-to-another-access-database-HA001227659.aspx

Compare two tables and find records w/o matches
http://office.microsoft.com/en-us/a...find-records-without-matches-HA010205132.aspx

Update data from one table to another
http://office.microsoft.com/en-us/access-help/update-data-by-using-a-query-HA010076527.aspx

Here is my code:
UPDATE [tblFILES-Feb19] LEFT JOIN tblFILES ON [tblFILES-Feb19].[PATTMNO] = tblFILES.[PATTMNO] SET tblFILES.PATTMNO = [tblFILES-Feb19].[PATTMNO] WHERE (((tblFILES.PATTMNO) Is Null));
When I run the update query, I receive the error below:
Mircrosoft Office Access didn't update 0 field(s) due to type conversion failure, 0 record(s)... Read more

A:Solved: Update Data From a Compare Data Field Query

Read other 6 answers
RELEVANCY SCORE 45.2

I just got my computer up and running yesterday, but I've noticed this screen when I turn it on. It pops up before the OS loads. My computer is running just fine, but this is just kind of an annoyance to see. Is there any way to remove it? I've got a Gigabyte ga-ma790fxt-ud5p and running Windows 7 Home Premium.

A:How to remove the screen that shows "AMD Data Change... Update New Data To DMI!"?

This is a message from your motherboard, not windows 7.

Did you enter the BIOS (settup) and load the default settings? Or change any other settings?

Read other 7 answers
RELEVANCY SCORE 45.2

Microsoft have moved their Windows Autorun V2.1 [1] (967940) update patch from optional updates to automatic updates. This is the same patch that was released in last month?s patch Tuesday. When Windows update is next run, this patch will automatically be selected to apply to your machine. This is more likely to affect home users, as companies should be using group policies to control how USB autorun settings operate.Microsoft?s Autorun update v2.1 now automatically deployed from Windows Update <- Published: March 3, 2011Microsoft Security Advisory (967940): Update for Windows Autorun <- Published: February 24, 2009; updated February 22, 2011

Read other answers
RELEVANCY SCORE 45.2

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you can
 

A:Excel: Automatically import data from another workbook

bparker said:

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you canClick to expand...

Hi bparker - Not sure I'm reading your intent right, but if you can save the "19991118damlbmp_zone" etc sheets into a book on the desktop you name "Book11" and then open a new book called "Book10" and run the code from Book10 - you can use something like this:

Code:
[SIZE=2]Sub COPYIT()
'this is run from the book named Book10
Dim N%
Application.ScreenUpdating = False
On Error Resume Next '<< error is - "books already open"
Workbooks.Open Filename:="C:\WINDOWS\Desktop\Book11.xls"
For N = 1 To Sheets.Count
Workbooks("Book11.xls").Activate
Sheets("Sheet" & N).Select
Range("A1", Range("A65536").End(xlUp).Rows.EntireRow).Select
Selection.Copy
Windows("Book10.xls").Activate
Sheet... Read more

Read other 3 answers
RELEVANCY SCORE 45.2

Hi all,

I have a monthly report that has a certain column (always column BF) that contains the numbers 1-5, either singly or in any combination thereof. I have to copy this into 5 columns (BQ through BU) and I want those columns titled Q2 - 1, Q2 - 2, Q2 - 3, Q2 - 4 and Q2 - 5.
I need all the 1s in Q2 - 1, all the 2s in Q2 - 2 and so on.
Since the number of items in each cell varies, (there is no 1, , 3,4, , with blanks for non-existing numbers, rather one cell may have 2 and the one below it may have 1,3,5) is there a macro or a formula that would quickly copy every item into the right column?
It isn't vital, I suppose, I can copy, sort and cut and paste, but I would like to save the time....

Thanks in advance
 

A:Solved: Excel 97 - want to automatically move data

Read other 9 answers
RELEVANCY SCORE 45.2

I was doing routine computer work on the evening of 8/19/15 when I started getting warnings from Verizon Wireless about my JetPack data utilization. (I am on a 5GB/month plan, and 3.55+GB were used in that one evening.)

The tech at Verizon said the usage occurred in the "Communications and Device Services," which includes Windows updates and stuff I don't use (such as Skype).  My computer's update history shows only one update on 8-19-15, and that is

"Security Update for Internet Explorer 11 for Windows 7 for x64-based Systems (KB3087985).
Could that update possibly have used 3.55 GB of my data allowance?  What is the maximum it could have used?

Read other answers
RELEVANCY SCORE 45.2

Hi Guys,

I've an excel sheet which has some data and I want that excel to be automatically mailed every month end to few mail ID's. How to acheive this ?

-santhu
 

A:Excel should mail its data everymonth end automatically

Read other 11 answers
RELEVANCY SCORE 45.2

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you can
 

Read other answers
RELEVANCY SCORE 45.2

I'm in the process of upgrading to a new/used laptop. I plan on using a utility called Transwiz, which is a pretty simple and effective program. The twist here is that my present pc has 2 profiles as follows:

In my present pc (I now call the FROM pc), there are two profiles I need to transfer as one profile. So, what I thought I would do is go into C:/Users/Profile1 and Profile2 and copy some files from one to the other (only files in Documents, Downloads, Music, etc. I'm not fooling with the other system like folders such as App Data. I've already installed the same programs in the new pc (the TO pc). So, the settings will automatically transfer with Transwiz.

My question is: Can I move files from one profile to the other, then delete the profile I won't need, and only transfer the modified one? Are there any hooks there? BTW, the FROM pc is Win 10, and the TO pc is Win 7 (I know this sounds backwards, but I have good reason to do so).

I appreciate anyone's guidance!!
 

A:Merging Selected Profile Data Into One Profile

I use Transwiz on a regular basis, and it really is a good program. If you're only moving the files you mentioned, that shouldn't be a problem at all.
 

Read other 1 answers
RELEVANCY SCORE 44.8

I have a table that logs files out.

When the item comes back in I wish to record the date the file was returned.

How can I get it so the query (form) only brings up the one record to edit?

I've tried setting the parameter to ask for the IDCode (autonumber) but it does not bring any records up to edit?

I can get it so that I can edit everything from a certain date, or a department or a person but NOT where parameter [IdCode] is entered in the field "ServIdCode_fld"

Having been able to finally get bar codes to print properly I'm hoping that I can just scan the bar code in the appropriate record is brought up I can entered the date and go to the next file return.
 

A:Solved: Update Data - Select the Data with a parameter

Read other 16 answers
RELEVANCY SCORE 44.8

Windows Vista 64bit
was HP Desktop m8457c
but motherboard died so I purchased
gigabyte GA-880GM-D2H (rev. 3.1)
AMD 880G socket AM3
I updated my memory with PATRIOT gaming i5 8gb DDR3 1333MHz 9-9-9- kit
it is UNGANGED

I had to change CPU to match
it is AMD phenom II X6 1100T black edition
3.3GHz
Everthing worked perfect from Nov 7 until Dec 20
then one morning after internet auto update I found
DMI Pool Data
AMD data change Update new data to DMI!
Boot from CD/DVD
Disk boot failure insert system disk and press enter
I tried many things other have here on this forum
my problem is that in Master 2 is the original HARD DRIVE Slave 2 CD/DVD Master 3 which is the second hard drive, but BIOS sees it as the same hard drive as Master 2. It is a shadow copy of the 1rst HD and is same size.
I have turned each off independently in BIOS, but no OS will boot. Tried original recovery disk with system error not able to recover (BECAUSE OF new motherboard).
HELP
 

Read other answers
RELEVANCY SCORE 44.8

Hello. I work in a computer store in Indonesia as an administrator. My job is to create invoices. My crazy supervisor wants to see trimmed label address. She said it's more beautiful to look at -,-' Problem is the address I receive is always jumbled into one long line. Separating them (based on street address, etc) takes time. During the national shopping day, where we can have like 500 invoices in a day, I don't think I can handle it.

Below is one example of the address data that I have to work with:
17082509333FJ40
Alamat Pengiriman
Agus, 62812345678
Perumahan Orang Kaya, Jl.Jalan 2 BLOK H1/1001, Katulampa, Bogor Barat, KOTA BOGOR, BOGOR Barat - KOTA, JAWA BARAT, ID, 12345

The result I want is:
17082509333FJ40
Agus
Perumahan Orang Kaya
Jl.Jalan 2
BLOK H1/1001
Katulampa
Bogor Barat
KOTA BOGOR
12345
'0812345678

Of course, I understand it is impossible for a script to wholly replace man's logic. But if the script can help me create new lines based on several conditions, it will greatly help me. The conditions are as follow..
New line is made immediately before:
1. Word "Jalan" or "Jl." or "Jl"
2. Word "Perumahan" or "Perum"
3. Word "Blok" or "Block"
4. Word "RT" or "RT***" (*=number)
5. Word "Gang" or "Gg." or "Gg"
6. Word "Kel." or "Kel" or "Kelurahan"
7. Word "Kec." or "Kec" or... Read more

Read other answers
RELEVANCY SCORE 44.8

Hi there! I'm creating an access database for our company's mailing list.

I have two fields in my form named ID1 and ID2. When I create a new record, I would like Access to copy the information from ID1 into the ID2 field, and add three letters to the beginning of the data.

In other words, if ID1 is "123" i would like ID2 to automatically be generated as "RTC123".

ID1 is an autonumber field if that makes a difference.

Is this possible to do? How would I go about making it happen?

Thanks!
 

A:Access 2003: Copying data automatically from one column to another

Hello, if the data is already in column 1 then you can use an update query to transfer the data to column 2.
If the data in column 1 is to be entered in a form then the transfer can be made as the data is entered.
Which way do you need to do it?
Or do you need to do it both ways.
Also why do you need to store the data like that if it can be created and displayed like it at any time?
 

Read other 1 answers
RELEVANCY SCORE 44.8

I would like to backup my important documents online. ( One particular drive or folder )

Any software that automatically backups the data online.
 

A:Any software that automatically backups and synchronizes the data online?

Here's one.
http://www.xdrive.com/backup.jsp
 

Read other 2 answers
RELEVANCY SCORE 44.8

i have a severe problem. whenever i use connect option and get connected to internet, data starts to downloaded automatically. i fear some programmes are running in the background unnoticedd. how can i stop this so that i can save my banwidh and hence money?

A:Automatically data sent received whenevr I connect to Broadband WAN

  
Quote: Originally Posted by bhasphys


i have a severe problem. whenever i use connect option and get connected to internet, data starts to downloaded automatically. i fear some programmes are running in the background unnoticedd. how can i stop this so that i can save my banwidh and hence money?


Welcome Bhasphys to the windows 7 forums.

What you can do is to see what programs are loading when you boot. you can run msconfig in the run window as administrator and there are options to see what is starting when you boot.

Many programs like your Anti-Virus and such check for updates when you boot to make sure that you have the latest version and updates.

There are other programs, most free that will let you see what programs are starting up when you boot your computer.

I use a program called startupinspector to check and uncheck programs that startup when I boot.

Search on startupinspector with google.

Rich

Read other 3 answers
RELEVANCY SCORE 44

I have a spreadsheet that connects to a database.
When I open the spreadsheet, I got asked if I wanted to refresh the data. I did so, and clicked yes.
Some time later, after getting bored ticking 'yes' every time I opened the sheet I ticked the 'don't ask me again' button.
Now every time I open a sheet that pulls data from a remote data source, it automatically connects and updates the data - I no longer want this to happen!!!!! Any way I can switch this off as easily as I switched it on????

andy
 

A:how do i stop EXCEL automatically updating from a remote data source?

hilight all live data and right click and select Data Range properties. Remove the tick from Enable Background Refresh. then ok then Save.
 

Read other 2 answers
RELEVANCY SCORE 44

Afternoon everyone!

I am trying to get a little bit of code working such that when a user enters in some data in column A, it triggers code in VBA to paint a simple surround black border over the whole row, from column A to M. Here is what I have so far, but it doesn't seem to be working. I know I am missing something (if not a lot).
Code:

Dim i As String

If ActiveCell.Column = 1 Then
If ActiveCell.Value <> "" Then
Range(Cells(i, 1),Cells(i, 13)).Borders.LineStyle = Excel.xlLineStyle.xlContinuous
Else
End
Else
End

I appreciate any help! Thank you in advance!
 

A:Solved: VBA in Excel: Automatically paint borders on data entry

Hi Maxx, you shouldn't forget to mention the version of Excel you're using

Place this code in the sheet
Code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column <= 13 Then
If Target.Value <> "" Then
Range("A" & Target.Row & ":M" & Target.Row).Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlInsideVertical)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
Target.Offset(0, 1).Select
End If
End If
End Sub
 

Read other 2 answers
RELEVANCY SCORE 44

I've have an Aspire x1300 for many years. The only mods I've done to it is add a new graphics card, a MSI radeon R7 200. For the past couple months, every time I boot up "AMD Data Change...Update New Data to DMI" appears on the boot up screen and doesn't do anything from there. The only way I can start my comp is to go into the bios menu and back out. I looked up many options and the only one that makes sense is to update the bios but there are no drivers available for my model on this site. Does anyone have to right bios update for me or a proper solution? please help.

A:AMD Data Change...Update New Data to DMI message a...

http://us.acer.com/ac/en/US/content/drivers/1180;-;Aspire%20X1300 click on BIOS tab, be aware that those updates are only for BIOS version Rxxxx one thing i would try is to change the CMOS battery, probably a low charge battery can have this kind of behaviour.

Read other 4 answers
RELEVANCY SCORE 43.6

I have a new Yoga 720. For the 3rd or 4th time it's reset itself and lost all of my data- outlook, quicken, the programs are still there but they are empty and it's like I never input any of the information. I contacted tech support and was told I would need to pay to get help with this ... which makes no sense to me as it is a new computer that isn't working correctly.

Read other answers
RELEVANCY SCORE 43.6

I use Comcast as my ISP. They provide a Data Meter so I can check on my data usage and not go over the 250GB monthly limit. I check it daily. Yesterday it was at 56 GB for the entire month. Today when I checked it, it was at 110 GB - it had doubled almost overnight.
 
This computer has recently shown a change in behavior. I use the Google Chrome browser and I have noticed that a new tab will suddenly be created without any input from me. The new tab is created but focus does not shift to it - I still remain in the current tab.  I have never viewed the new tab after it has been created. I just close it by clicking the little X, but I have noticed that the new tab contains things like the FBI scare warning about malware on my computer or the new tab is a web site containing  some kind of porn. This new tab is created randomly - I cannot recreate this occurrence on demand.
 
I have run full system scans of Malwarebytes and Microsoft Security Essentials and nothing was found.
 
 
DDS (Ver_2012-11-20.01) - NTFS_x86 
Internet Explorer: 9.0.8112.16526  BrowserJavaVersion: 10.51.2
Run by Robert at 9:27:10 on 2014-01-21
Microsoft® Windows Vista™ Home Premium   6.0.6002.2.1252.1.1033.18.3006.1091 [GMT -8:00]
.
AV: Microsoft Security Essentials *Enabled/Updated* {641105E6-77ED-3F35-A304-765193BCB75F}
SP: Windows Defender *Disabled/Outdated* {D68DDC3A-831F-4fae-9E44-DA132C1ACF46}
SP: Microsoft Security Essentials *Enabled/Updat... Read more

A:Dramatic Increase in Data Usage and New Tabs in Chrome Created Automatically

Hello and welcome to Bleeping Computer! I am HelpBot: an automated program designed to help the Bleeping Computer Staff better assist you! This message contains very important information, so please read through all of it before doing anything.
We apologize for the delay in responding to your request for help. Here at Bleeping Computer we get overwhelmed at times, and we are trying our best to keep up. Please note that your topic was not intentionally overlooked. Our mission is to help everyone in need, but sometimes it takes just a little longer to get to every request for help. No one is ignored here.
To help Bleeping Computer better assist you please perform the following steps:
*************************************************** In order to continue receiving help at BleepingComputer.com, YOU MUST tell me if you still need help or if your issue has already been resolved on your own or through another resource! To tell me this, please click on the following link and follow the instructions there.CLICK THIS LINK >>> http://www.bleepingcomputer.com/logreply/521575 <<< CLICK THIS LINK
If you no longer need help, then all you needed to do was the previous instructions of telling me so. You can skip the rest of this post. If you do need help please continue with Step 2 below.
***************************************************If you still need help, I would like you to post a Reply to this topic (click the "Add Reply" button in the lower right hand of t... Read more

Read other 28 answers
RELEVANCY SCORE 43.6

I have a new Yoga 720. For the 3rd or 4th time it's reset itself and lost all of my data- outlook, quicken, the programs are still there but they are empty and it's like I never input any of the information. I contacted tech support and was told I would need to pay to get help with this ... which makes no sense to me as it is a new computer that isn't working correctly.

Read other answers
RELEVANCY SCORE 43.6

whenever i open task scheduler I keep getting the message

Error: selected task (o) no longer exists. To see the current tasks click refresh.

even after repeated clicking refresh the same message is displayed.

also on both task status and active tasks it says Reading data failed

wats happening?

A:Task scheduler (win7) fails to read data. Error: "selected task (o) no longer exits"

Can you not remove (o) from the scheduled task list?

If not then it might be that Task Scheduler has been corrupted by something, not sure how task scheduler is stored, but in system32 there is 3 files (taskschd.dll, taskschd.exe, TaskSchdPS.dll) that are all related to Task Scheduler, but not sure if any of them could be the cause of this issue.

Read other 1 answers