Hi, try to use this spreadsheet to import from MS Access
http://goo.gl/YxPK6
Em sábado, 20 de julho de 2013 01h07min46s UTC-3, Chinnumanas escreveu:
>
> Team.. Pls help
>
> -- Forwarded message --
> From: vijayKumar >
> Date: Fri, Jul 19, 2013 at 7:20 PM
> Subject: $$Excel-Macr
Hi sir
In that file master sheet u entered 3rd july values.if i enter date 3rd
july at report sheet error showing at 2nd july values column? please help.
On Fri, Jul 19, 2013 at 3:26 PM, Pravin Gunjal wrote:
> PFA.
>
> Regards
> Pravin Gunjal.
>
> -- Forwarded message --
> From:
The DoCmd.TransferSpreadsheet command, when activated with parameter
acSpreadsheetTypeExcel12, is able to export more than 65,536 rows.
So, create a macro (mcr_Exportation) and add the action "ImportrExport
workbook "; Transfer Type: Export, type spreadsheet: Excel Workbook; Table
Name: YourQuery
Team.. Pls help
-- Forwarded message --
From: vijayKumar
Date: Fri, Jul 19, 2013 at 7:20 PM
Subject: $$Excel-Macros$$ Export Table Created in Access(2007)
To: excel-macros@googlegroups.com
Dear Team,
Kindly suggest how to export a table from MS access.
Please find the below gi
It depends on the preference of each. I suggest an idea for improving the
performance of file since lighter and worked up data
Em sexta-feira, 19 de julho de 2013 03h38min32s UTC-3, Waseem Saifi
escreveu:
>
> Dear Experts,
>
>I have an Excel file. which has huge amount of data. it has mo
Hi Experts,
if anyone have template for Ramp Up plan which is used for staffing
forecast. pls share. if possible i need explanation for the terms which is
used in that file.
Thanks & Regards,
Prabhu R
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N
Hmm... I have to disagree.
I have an excel workbook that has 75 columns and 127,000 rows (and growing).
THEN, the workbook has 20 sheets that report this data in different formats,
and are used for queries against the data.
I consider THIS "a lot of data".
however, compared to the 5 million re
Thanks for the compliment.
Excel isn't a "solution".. it is a tool kit.
Once you "master" one of the "tools", you combine it with other tools to CREATE
a "solution".
It takes a bit longer, but if I instead describe the thought processes involved
in the selection of the "tools", then you are b
eliminate the Ptrsafe then try. it is because of the excel version issue i
hope so.
On Friday, July 19, 2013, De Premor wrote:
> I dont know why, but in my laptop also Rajan that Declaration running
well without any problem
>
> I get that formula from Rajan :D, maybe he know why (^_^)
>
> Pada 1
Hi Rajan, since we're using looping method for do that job we cant do
anything until that looping finished.
Pada 19/07/2013 12:22, Rajan sharma menulis:
Premor sir,
While running the macros, Meanwhile can we do work ? i mean in rest
of the cells. Say i have type 500, now it will start runn
Dear Team,
Kindly suggest how to export a table from MS access.
Please find the below given screen shot of the macro which is created.
This macro gives output only 65000 rows.
Kindly Suggest asap..
[image: Inline image 1]
--
Vijay
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y
Dear Prabakar,
Follow the bellow mentioned steps :-
- Select whole sheet by CTRL+A
- Press CTRl+1 for open Format Cell
- Go to Protect Tab and uncheck the lock and hidden checkbox.
Then After,
- Select the cell, column or row which you want to lock
- Go to Format Cell
- Cl
Not clear what you are trying to do but if your master sheet has different
names and you are trying to sum for your report sheet try the following:
=SUMIF(MASTER!$B$5:$B$35,"Raman Choudary",MASTER!C5:C35)
That goes into B9 of your report sheet. You can then copy across. If B10 is
a different
Respected Prabhakar,
First select all the sheet and go to format tab and go to the protection
tab and uncheck the locked and hidden chechmarks.Then Select the Cells,Rows
or Columns which you want to lock,the go to the format tab and then the
protection tab in the dialog box then check the locked
Hi Sandeep, has to do with what you need.
I need to know:: The database access is within the SQL server?
tks. and rgs.
On Wednesday, July 17, 2013 11:48:43 AM UTC-3, Sandeep Kumar Baranwal wrote:
>
> Hi
>
> Kindly note that sql.request is functional in MS Excel 2007 but not in MS
> Excel 201
Excel does not support a lot of data. I think the ideal would be to store
the data on another worksheet, or access and process the data and make
queries on the worksheet page.
Em sexta-feira, 19 de julho de 2013 03h38min32s UTC-3, Waseem Saifi
escreveu:
>
> Dear Experts,
>
>I have an Ex
Yeah,
I modified it and worked perfectly.
Here is how's it now.
=SUM(INDIRECT(ADDRESS(MATCH(A2,$G$1:$G$14,0),8) & ":" &
ADDRESS(MATCH(A2,$G$1:$G$14,0),MATCH($D$1,$H$1:$Z$1)+7)))
Thanks again.
On Fri, Jul 19, 2013 at 3:29 PM, Excel_Lover wrote:
> Dear Mr.Paul,
>
> I am sorry I didn't menti
Dear Mr.Paul,
I am sorry I didn't mentioned it in first e-mail.
I like your posts in this groups because you are the only one who posts
solutions with enough explanation.
I will try the formula with suggested changes and will get back to you with
the feedback.
Thanks for your time and help.
In your first message, you didn't mention that the value in column A may not
match the values in the row!
The solution I provide could be used.
simply use the MATCH() function to return the row number of the matching value
from column A and use that instead of the ROW() functions I used.
Paul
Here's my answer:
=SUM(INDIRECT(ADDRESS(ROW(),8) & ":" & ADDRESS(ROW(),MATCH($D$1,$H$1:$Z$1)+7)))
Here's my logic:
You want to use the =SUM() function to calculate the total
for the current row from column H1 through the column described in D1.
For Jun-12, the SUM() function would look like:
=S
Dear Mr.Deepak,
Thanks for a quick reply, your formula works fine but it's not considering
the items (A,B,C,D etc), it should also be a criteria because its order may
vary.
Hope it needed a formula like SUMIF which provides SUM by multiple
criteria.
Thanks again..
On Fri, Jul 19, 2013 at 2:58
On Fri, Jul 19, 2013 at 5:05 PM, Excel_Lover wrote:
> Dear All,
>
> Attached is a sample data in which I have some month wise item total, I
> need a formula which can calculate SUM of an item from the Month Jan-12 to
> till the month which we are selecting in the column D1.
>
> Appreciate if som
Dear Team,
I know how to protect sheet. but not able to protect / lock particular cell
/ row and column in Excel. Can you pls help in attached excel sheet how to
do it.
Also pls tell me how to protect Formulas in Excel.
Rgds,
Prabhakar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? An
I've encountered similar issues before.
It seems to be a graphical memory issue.
Usually, I have several applications open at once.
At some point, the memory on the graphics card is exhausted.
Even when you exit the other applications, sometimes the graphics memory isn't
released.
My PC was upgr
Dear All,
Attached is a sample data in which I have some month wise item total, I
need a formula which can calculate SUM of an item from the Month Jan-12 to
till the month which we are selecting in the column D1.
Appreciate if somebody can help me with formula.
Best Regards
Excel_Lover
--
Are
thanks for suggestion.can u explain
On Fri, Jul 19, 2013 at 2:38 PM, Pravin Gunjal wrote:
> Pl use v-lookup.
>
> -- Forwarded message --
> From: excel lerner
> Date: Fri, Jul 19, 2013 at 10:20 AM
> Subject: $$Excel-Macros$$ formula required to update values form one sheet
> to
Dear Sir,
Operating System is Microsoft Windows 7,
Processor is Intel Pentium Dual Core with 2.6 Ghz speed.
RAM is 2 GB.
Hard disk is approx 500 GB.
Regards,
Waseem Saifi
On Fri, Jul 19, 2013 at 1:29 PM, vba wrote:
> Hi
>
> Also state operating system you are using along with PC configuratio
Dear CGMAURYA,
The file is attached along with this post.
All details are mentioned below and same is also mentioned in my first post
along with attached file.
Regards
Vijay Yadav
On Friday, 19 July 2013 11:18:16 UTC+5:30, CGMAURYA wrote:
>
> Dear Vijay,
>
> Where is attached excel file.
>
Hi
Also state operating system you are using along with PC configuration and
RAM.
Its likely possible that low configueration and RAM may cause it.
Thanks
On 19 Jul 2013 12:08, "Waseem Saifi" wrote:
> Dear Experts,
>
>I have an Excel file. which has huge amount of data. it has more
> than
Dear Vikas,
Can you please explain. what is this or how it works.
Thanks
Ashish
On Thursday, July 18, 2013 10:48:02 PM UTC+5:30, vikas wrote:
>
> Jvo gv Buchanan! R g chives PBS:;,?! Gyvfchvjbhjvijvonvpvpvppp0
> On Jul 18, 2013 9:42 PM, "Ashish Kumar" >
> wrote:
>
>> Dear Seniors,
>>
>> I want
30 matches
Mail list logo
